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

Re: selects from large tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: Nikk Anderson <Nikk(dot)Anderson(at)parallel(dot)ltd(dot)uk>,pgsql-performance(at)postgresql(dot)org
Subject: Re: selects from large tables
Date: 2002-11-18 15:03:33
Message-ID: 29169.1037631813@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

pgsql-performance by date

Next:From: Nikk AndersonDate: 2002-11-18 15:31:34
Subject: Re: selects from large tables
Previous:From: FedericoDate: 2002-11-18 15:02:17
Subject: Re: for/loop performance in plpgsql ?

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