From: Tom Lane <tgl@sss.pgh.pa.us>
To: Steven M. Wheeler <swheeler@sabre.com>
Cc: pgsql-sql@hub.org
Subject: Re: [SQL] Questions about vacuum analyze
Date: Tue, 12 Oct 1999 11:17:40 -0400
Message-ID: <16693.939741460@sss.pgh.pa.us> (raw)
In-Reply-To: <38034BF5.AE40BBB4@sabre.com>
"Steven M. Wheeler" <swheeler@sabre.com> writes:
> I tried your suggestion for -S 32 through -S 1 running a select
> distinct against my history table. I normally run with -S 2048 on the
> startup of the master process. FYI: the history table uses the same
> layout as the currnt table, its just an hourly summation of the minute
> by minute data in currnt. history has 189,724 records.
> Bottom line: The select never failed.
My current theory is that you were running out of disk space or else
running up against a 4-gig-per-temp-file limit in the sort that's done
for SELECT DISTINCT. So -S wouldn't really affect matters, and testing
on a smaller table definitely won't prove anything one way or the other.
BTW, I believe -S 32 is the smallest value the backend will actually
accept --- it just ignores any attempt to set a smaller value.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, swheeler@sabre.com, pgsql-sql@hub.org
Subject: Re: [SQL] Questions about vacuum analyze
In-Reply-To: <16693.939741460@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox