Performance of using tablespaces to seperate indexes and tables to different disks

From: Benjamin Arai <benjamin(at)araisoft(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Performance of using tablespaces to seperate indexes and tables to different disks
Date: 2007-04-12 19:17:46
Message-ID: 461E85DA.1000702@araisoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

By separating tables and indexes onto different drives through the use
of tablespaces does this increase COPY or CREATE INDEX performance? If
you have a ballpark figure of how much gain if any, that would be great too.

Benjamin

Browse pgsql-general by date

  From Date Subject
Next Message Benjamin Arai 2007-04-12 19:20:57 pg_dump when database contains multiple tablespaces
Previous Message Dave Page 2007-04-12 18:46:46 Re: Bugs not appearing in list archives