Re: Compression and on-disk sorting

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Greg Stark <gsstark(at)mit(dot)edu>, "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>, Martijn van Oosterhout <kleptog(at)svana(dot)org>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Rod Taylor <pg(at)rbt(dot)ca>, "Bort, Paul" <pbort(at)tmwsystems(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Compression and on-disk sorting
Date: 2006-05-18 17:50:06
Message-ID: 200605181750.k4IHo6m27691@candle.pha.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > Uh, TODO already has:
>
> > o %Add a GUC variable to control the tablespace for temporary objects
> > and sort files
>
> > It could start with a random tablespace from a supplied list and
> > cycle through the list.
>
> > Do we need to add to this?
>
> The list bit strikes me as lily-gilding, or at least designing features
> well beyond proven need.

I have seen other databases do the round-robin idea, so it is worth
testing.

--
Bruce Momjian http://candle.pha.pa.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephen Frost 2006-05-18 17:51:05 Re: [OT] MySQL is bad, but THIS bad?
Previous Message Tom Lane 2006-05-18 17:42:54 Re: Compression and on-disk sorting

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2006-05-18 17:51:00 Re: [PATCHES] small doc patch for regexp_replace
Previous Message Tom Lane 2006-05-18 17:47:23 Re: [PATCHES] small doc patch for regexp_replace