From: | Nikk Anderson <Nikk(dot)Anderson(at)parallel(dot)ltd(dot)uk> |
---|---|
To: | 'Tom Lane' <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: selects from large tables |
Date: | 2002-11-18 15:36:08 |
Message-ID: | DA1274E682D3734B8802904A9B36124C298A96@nic-nts1.nic.parallel.ltd.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2002-11-18 15:43:02 | Re: selects from large tables |
Previous Message | Nikk Anderson | 2002-11-18 15:31:34 | Re: selects from large tables |