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; Rag

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

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

2005-06-07 Thread Mohan, Ross
ERAL] Things I learned about PG8 on AIX5.3 with XLC compiler [EMAIL 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 --

[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 t

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; pgsql-hackers@postg

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

2005-05-29 Thread Mohan, Ross
general@postgresql.org Cc: 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 ord

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

2005-05-28 Thread Mohan, Ross
track (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@postgresq

[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 j

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 To

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 u

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] 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] Pos

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. I wonder what the best way to spend $7K for performance improvement might be? ;-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jim C. Nasby S

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). I hope he enjoys his ongoing reviews; I suppose it can't hurt? -Original Message- From: [EM

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 Ic

[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
f III [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]> wrot

[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