Re: [GENERAL] indexes are farked

2005-08-02 Thread Mohan, Ross
BINGO. Noticed that, too. Guess all the energy was used getting up on the high horse. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Marlowe Sent: Tuesday, August 02, 2005 5:09 PM To: Joshua D. Drake Cc: Bob Pawley; Jaime Casanova; Dr NoName;

Re: [GENERAL] [PERFORM] Projecting currentdb to more users

2005-07-12 Thread Mohan, Ross
From AMD's suit against Intel. Perhaps relevant to some PG/AMD issues. ...125. Intel has designed its compiler purposely to degrade performance when a program is run on an AMD platform. To achieve this, Intel designed the compiler to compile code along several alternate code paths. Some paths

[GENERAL] Things I learned about PG8 on AIX5.3 with XLC compiler

2005-06-07 Thread Mohan, Ross
Just a short,terse list: Don't use nondefault optimization. There is something going on with the code that breaks, runtime, when compiled (which works fine per se) with higher optimization levels. IPA is a real difficulty. Remember to set OBJECT_MODE=64 in OS env! upgrading m4/autoconf and

Re: [GENERAL] Things I learned about PG8 on AIX5.3 with XLC compiler

2005-06-07 Thread Mohan, Ross
PROTECTED] (Mohan, Ross) writes: It would be worthwhile to try to formulate this as a patch to the FAQ_AIX file. Probably something like PostgreSQL 8 on AIX 5.3, compiled using VisualAge C -- - Use only default optimization. Higher optimization

Re: [GENERAL] [PORTS] Major flood of mail to lists ...

2005-05-31 Thread Mohan, Ross
Wow, you mean mail besides my own is considering to be junk? ;-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc G. Fournier Sent: Tuesday, May 31, 2005 1:46 PM To: pgsql-announce@postgresql.org Cc: pgsql-general@postgresql.org;

Re: [GENERAL] Fast request for version checking....

2005-05-29 Thread Mohan, Ross
: Subject:Re: [GENERAL] Fast request for version checking Oops! [EMAIL PROTECTED] (Mohan, Ross) was seen spray-painting on a wall: I have 2.53, yes. But, I am going to rebuild and re-AC this, so need to build m4 (1.4.3) in order to get to 2.59 of AConf. Any reasons to strongly advocate

Re: [GENERAL] Fast request for version checking....

2005-05-28 Thread Mohan, Ross
(ANSI compliant or not) with all builds. An RTFM pointer to a doc would be more than ample, if such explanation already exists! Thanks!! -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Fri 27-May-05 8:35 PM To: Mohan, Ross Cc: pgsql-general@postgresql.org

[GENERAL] Fast request for version checking....

2005-05-27 Thread Mohan, Ross
Folks, if you go to the root of your postgresql distro and type ./configure --version what version of AutoConf was used? thanks! --Ross ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your

Re: [GENERAL] Compiling Postgresql 8.0.3 on Solaris 10

2005-05-25 Thread Mohan, Ross
After 5 seconds of intense thought, I suggest that you check the privileges on your compiler stuff. Please keep posting and let us know how you fared. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Aly Dharshi Sent: Wednesday, May 25, 2005 4:12 PM

Re: [GENERAL] Clustering Database Servers

2005-05-09 Thread Mohan, Ross
Slony is the master-slave (not multi-master IIRC) replication environment. I haven't used it, but apparently there are cognoscenti among us who have. I would think, a bit, about what kind of load (e.g. CPU, network, disk queues, disk allocation, et cetera) you want to balance before picking up

Re: [GENERAL] Postgres vs Firebird?

2005-05-04 Thread Mohan, Ross
while we're on scalability, any thoughts on needs/plans for 64-bit PG? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Marlowe Sent: Wednesday, May 04, 2005 3:19 PM To: [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL]

Re: [GENERAL] Postgres vs Firebird?

2005-05-04 Thread Mohan, Ross
LOL! (thanks) Redfaced, and going back to check compiler flags, -- Ross -Original Message- From: Joshua D. Drake [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 04, 2005 3:42 PM To: Mohan, Ross Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Postgres vs Firebird? Mohan

Re: [GENERAL] Favorable Postgresql write up

2005-05-03 Thread Mohan, Ross
It's nice, but...it couldn't possibly be more subjective, and his ranking of documentation as 5 out of 10 is funny. He apparently did not even find these many hosted listservs (only Usenet). shrug I hope he enjoys his ongoing reviews; I suppose it can't hurt? -Original Message- From:

Re: [GENERAL] Very interesting article about the future of databases

2005-05-03 Thread Mohan, Ross
w/o reading the URL docs, it sounds suspiciously like tagged command queueing for sequential scans. pause for comedic effect I wonder what the best way to spend $7K for performance improvement might be? ;-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On

Re: [GENERAL] UltraSPARC versus AMD - Slowaris

2005-04-26 Thread Mohan, Ross
Richly deserved IMNSHO. my current employer was bilked for many many months for a piece of crap E10K that barely outperforms a couple of AMD chips. But at many, many times the price. We finally upgraded/migrated to AIX/g5 chips and run what was run on 20 cpus on 2. If Sun pulls out of its slow

[GENERAL] Install PG 8.0 on AIX 5.2? Any Veterans?

2005-04-06 Thread Mohan, Ross
Subject says it all...I've got to do this soon, and since I would like PG to take over this company like a VIRUS, I'd like this rollout to go *very* well. Any comments, caveats, encomiums, exhortations, anecdotes, war stories, gentle assurances and pointers of all sorts most welcome. - Ross

Re: [GENERAL] Oracle Migration. Don't Care about the Corbomite Maneuver, Spock.

2005-03-30 Thread Mohan, Ross
[mailto:[EMAIL PROTECTED] Sent: Wednesday, March 30, 2005 12:36 PM To: Mohan, Ross Cc: pgsql-general@postgresql.org Subject: Re: Oracle Migration. Don't Care about the Corbomite Maneuver, Spock. On Wed, Mar 30, 2005 at 00:35:25 -, Mohan, Ross [EMAIL PROTECTED] wrote: Any pointers? The online

[GENERAL] Oracle Migration. Don't Care about the Corbomite Maneuver, Spock.

2005-03-29 Thread Mohan, Ross
Hello Postgres'ers, Oracle newbie to PG here, curious about best books and online resources. A *lot* of what I am finding in google is one to four year old p*ssing contest with MySQL vs. Postgres (don't care) or Why doesn't PostGres support five level hypergalactic triple ACID Phase Inverters on