dbTalk Databases Forums  

Tablespace layout question

comp.databases.postgresql.general comp.databases.postgresql.general


Discuss Tablespace layout question in the comp.databases.postgresql.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Emil Briggs
 
Posts: n/a

Default Tablespace layout question - 06-22-2005 , 11:43 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.