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

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

pgsql-performance by date

Next:From: Nikk AndersonDate: 2002-11-18 16:32:49
Subject: Re: selects from large tables
Previous:From: Tom LaneDate: 2002-11-18 16:25:27
Subject: Re: selects from large tables

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