Re: selects from large tables

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Nikk Anderson <Nikk(dot)Anderson(at)parallel(dot)ltd(dot)uk>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: selects from large tables
Date: 2002-11-18 16:32:46
Message-ID: 20021118083059.P51208-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, 18 Nov 2002, Nikk Anderson wrote:

> Hi,
> Thanks for the reply Stephen, the data is 'somewhat' realistic.....

Tom's said most of what I would have, except that if you've got a wide
variation based on job_id you may want to change the statistics gathering
defaults for that column with ALTER TABLE ALTER COLUMN SET STATISTICS when
you get to 7.2.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Nikk Anderson 2002-11-18 16:32:49 Re: selects from large tables
Previous Message Tom Lane 2002-11-18 16:25:27 Re: selects from large tables