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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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