Re: selects from large tables

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(at)sss(dot)pgh(dot)pa(dot)us]
Sent: 18 November 2002 15:04
To: Stephan Szabo
Cc: Nikk Anderson; pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] selects from large tables

Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)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