Re: How to _really_use a non-default tablespace

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Andras Simon <szajmi(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to _really_use a non-default tablespace
Date: 2006-10-17 15:58:31
Message-ID: 20061017155831.GC12030@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Oct 17, 2006 at 05:54:42PM +0200, Andras Simon wrote:
> >The xlog is not split by database, all databases share the same xlog.
>
> OK, I see. The question then is how far does it grow. If its size is
> comparable to that of the actual data, then having separate
> tablespaces is not as useful as it first seemed to me. But I might be
> missing something.

xlogs are recycled. You can control the growth somewhat by playing with
the xlog settings in the config. It should stabilise at about 16MB
times the wal segments.

Have a nice dat,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andras Simon 2006-10-17 16:08:31 Re: How to _really_use a non-default tablespace
Previous Message Andras Simon 2006-10-17 15:54:42 Re: How to _really_use a non-default tablespace