Hi,
Unfortunately explain analyze does not work on our postgres version (7.1) ?
I think I will download and compile 7.2, and try to compile in 64bit mode to see if that helps improve performance.
Cheers
Nikk
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: 18 November 2002 15:04
To: Stephan Szabo
Cc: Nikk Anderson; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] selects from large tables
Stephan Szabo <sszabo@megazone23.bigpanda.com> writes:
> On Mon, 18 Nov 2002, Nikk Anderson wrote:
>> Any ideas on how we can select data more quickly from large tables?
> Are these row estimates realistic?
Showing EXPLAIN ANALYZE results would be much more useful than just
EXPLAIN.
regards, tom lane