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

From Rod Taylor
Subject Re: Filesystems WAS: Perfomance Tuning
Date
Msg-id 1060720839.83667.55.camel@jester
Whole thread Raw
In response to Re: Filesystems WAS: Perfomance Tuning  (Richard Welty <rwelty@averillpark.net>)
List pgsql-performance
> 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?

The ability to take various database objects and store them in different
locations, sometimes referred to as table spaces, will probably be done
in the future.  There was a substantial group not all that long ago that
was organizing to complete the implementation.

> or is it the judgement of the hackers community that a monsterous raid-10
> array offers comparable performance?

Often performs well enough... But a raid-10 for data, a stripe for
indexes, and a mirror for WAL will offer better performance :)

Attachment

pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Filesystems WAS: Perfomance Tuning
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Filesystems WAS: Perfomance Tuning