Re: Advantage of more than 1 tablespace on 1 disk?

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: "Thom Brown" <thombrown(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Advantage of more than 1 tablespace on 1 disk?
Date: 2008-11-03 11:14:46
Message-ID: 2f4958ff0811030314i76ffe0a5u81666574493ba9de@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

what you want in case of the table that gets read a lot, is partition +
cluster.
For table that changes a lot, I don't really know myself either. It is
usually trial and error type of scenario for me. (partitioning too, but that
depends on what parts are updated and under what conditions, etc).

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Emanuel CALVO FRANCO 2008-11-03 11:48:24 Re: PGDAY2008 (PostgreSQL)
Previous Message Thom Brown 2008-11-03 10:36:13 Advantage of more than 1 tablespace on 1 disk?