| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Martijn van Oosterhout <kleptog(at)svana(dot)org>, Phil Endecott <spam_from_postgresql_general(at)chezphil(dot)org>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Temporary tables and disk activity |
| Date: | 2004-12-13 05:54:12 |
| Message-ID: | 15910.1102917252@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Tom Lane wrote:
>> One of the things on the TODO list is making the size of temp-table
>> buffers user-configurable. (Temp table buffers are per-backend, they
>> are not part of the shared buffer arena.) With a large temp-table arena
>> we'd never need to write to the kernel in the first place. Right now
>> you could manually increase the #define that sets it, but it would not
>> pay to make it very large because the management algorithms are very
>> stupid (linear scans). That has to be fixed first :-(
> I assume you mean your TODO list because the official one has no mention
> of this.
Doesn't it? We've surely discussed the problem enough times, eg
http://archives.postgresql.org/pgsql-hackers/2002-08/msg00380.php
http://archives.postgresql.org/pgsql-hackers/2002-09/msg01368.php
or for that matter here's Vadim complaining about it seven years ago:
http://archives.postgresql.org/pgsql-hackers/1997-12/msg00215.php
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Stark | 2004-12-13 06:07:10 | Re: disabling OIDs? |
| Previous Message | Guy Rouillier | 2004-12-13 05:26:44 | Re: problem in connecting to postgreserver |