Tablespace layout question

Question posted by: Emil Briggs (Guest) on November 23rd, 2005 02:04 AM

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

Not the answer you were looking for? Post your question . . .
189,799 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).