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 cant 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, PostgreSQL
Matthews
Cc: [EMAIL PROTECTED]
Subject: Re: [PERFORM] Wierd issues
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
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)