Horton

Re: selects from large tables

Stephan Szabo <sszabo@megazone23.bigpanda.com>

View thread View on postgr.es
From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Nikk Anderson <Nikk.Anderson@parallel.ltd.uk>
Cc: <pgsql-performance@postgresql.org>
Date: 2002-11-18T16:32:46Z
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.