I lost the email that had the fix for this
and now I need it again… can someone or tom let me know what the fix was,
I can’t find it in any of my emails or archived on the internet
This is what I got…
Two servers, one debian, one fedora
Debain dual 3ghz, 1 gig ram, ide, PostgreS
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Friday, April 09, 2004 8:02 AM
To: Andrew Matthews
Cc: [EMAIL PROTECTED]
Subject: Re: [PERFORM] Wierd issues
"Andrew Matthews" <[EMAIL PROTECTED]> writes:
> [ PG 7.3.4 much slower than 7.2.1 ]
>
>
"Andrew Matthews" <[EMAIL PROTECTED]> writes:
> [ PG 7.3.4 much slower than 7.2.1 ]
>
> Both have same databases, Both have had vacume full ran on them.
You did ANALYZE too, right?
The bulk of the time is evidently going into the seqscan on users in
each case:
> -> Seq Scan
This is what I got…
Two servers, one debian, one fedora
Debain dual 3ghz, 1 gig ram, ide, PostgreSQL 7.2.1 on
i686-pc-linux-gnu, compiled by GCC 2.95.4
Fedora: Dual 3ghz, 1 gig ram, scsi, PostgreSQL 7.3.4-RH on
i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC
