Skip site navigation (1) Skip section navigation (2)

Re: selects from large tables

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 (view raw or flat)
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

Responses

pgsql-performance by date

Next:From: Andrew SullivanDate: 2002-11-18 15:43:02
Subject: Re: selects from large tables
Previous:From: Nikk AndersonDate: 2002-11-18 15:31:34
Subject: Re: selects from large tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group