| From: | Rod Taylor <rbt(at)rbt(dot)ca> |
|---|---|
| To: | Richard Welty <rwelty(at)averillpark(dot)net> |
| Cc: | PgSQL Performance ML <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Filesystems WAS: Perfomance Tuning |
| Date: | 2003-08-12 20:40:40 |
| Message-ID: | 1060720839.83667.55.camel@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 :)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Browne | 2003-08-12 21:43:29 | Re: Perfomance Tuning |
| Previous Message | Andrew Sullivan | 2003-08-12 20:40:22 | Re: Filesystems WAS: Perfomance Tuning |