By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 924 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

Tablespace layout question

P: n/a

I am working with an application whose performance is limited by the write
activity (inserts, updates and deletes) on three specific tables. The
database is RAM resident so read performance is not limited by the disk
speeds.

We are using Postgres 8 and I am wondering about the best way to set up
tablespaces. We have 3 disk arrays. Would it make more sense to place each
of tables 1,2 and 3 and their associated indexes on their own dedicated
array or would it be better to split each table and it's indexes across the
arrays? The activity pattern for the three tables is as follows

Table 1: Lots of inserts, updates and deletes. A lot of indexes and
searches.

Tables 2 and 3: Lots of updates, searches and indexes. Not too many inserts
or deletes.

Any insight would be appreciated.

Emil
Nov 23 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.