Re: Indexing on a separate volume

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>
Cc: mlw <markw(at)mohawksoft(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Indexing on a separate volume
Date: 2001-06-13 14:07:37
Message-ID: 200106131407.f5DE7cx03955@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On Wed, 13 Jun 2001, mlw wrote:
>
> > I was thinking this morning, how much work would it be to change the directory
> > structure of Postgres.
>
> Another useful change would be the addition of directory splitting in the
> database directories. This will increase performance on operating systems
> whose filesystem performance drops dramatically with a large number of
> files (say, large objects) in a single directory.

Good news is that in 7.1 large objects are all in one file. Again, see
the TODO.detail about tablespaces.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2001-06-13 14:08:37 Re: Patch to include PAM support...
Previous Message Zeugswetter Andreas SB 2001-06-13 14:01:32 AW: AW: vacuum