Re: Filesystems WAS: Perfomance Tuning

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Richard Welty <rwelty(at)averillpark(dot)net>, PgSQL Performance ML <pgsql-performance(at)postgresql(dot)org>, swm(at)linuxworld(dot)com(dot)au
Subject: Re: Filesystems WAS: Perfomance Tuning
Date: 2003-08-13 01:53:24
Message-ID: 200308130153.h7D1rOL15727@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


I think Gavin Sherry is working on this. I am CC'ing him.

---------------------------------------------------------------------------

Christopher Kings-Lynne wrote:
> > there are advantages to being able to split the database across a slew of
> > disk drives. if we accept the notion of using the native OS filesystem on
> > each, it would seem that being able to direct various tables and indices
> to
> > specific drives might be a valuble capability. i know that i could go into
> > /var/lib/pgsql/data/base and fan the contents out, but this is unweildy
> and
> > impractical. has any consideration been given to providing a way to manage
> > such a deployment?
>
> We've got a little bunch of us tinkering with a tablespace implementation.
> However, it's been staller for a while now.
>
> Chris
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Gavin Sherry 2003-08-13 02:07:47 Re: Filesystems WAS: Perfomance Tuning
Previous Message Richard Welty 2003-08-13 01:52:52 Re: Filesystems WAS: Perfomance Tuning