Postgres Pro
Downloads
Home   >   mailing lists

Performance of using tablespaces to seperate indexes and tables to different disks - Mailing list pgsql-general

From Benjamin Arai
Subject Performance of using tablespaces to seperate indexes and tables to different disks
Date
Msg-id 461E85DA.1000702@araisoft.com
Whole thread Raw
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Geoffrey
Date:
Subject: Re: backend reset of database
Next
From: Benjamin Arai
Date:
Subject: pg_dump when database contains multiple tablespaces