Re: Filesystems WAS: Perfomance Tuning - Mailing list pgsql-performance

From Bruce Momjian
Subject Re: Filesystems WAS: Perfomance Tuning
Date
Msg-id 200308130153.h7D1rOL15727@candle.pha.pa.us
Whole thread Raw
In response to Re: Filesystems WAS: Perfomance Tuning  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Responses Re: Filesystems WAS: Perfomance Tuning
List 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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-performance by date:

Previous
From: Richard Welty
Date:
Subject: Re: Filesystems WAS: Perfomance Tuning
Next
From: Gavin Sherry
Date:
Subject: Re: Filesystems WAS: Perfomance Tuning