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)
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
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