Re: Creating index on different tablespace and its temp files

From: Marcin Mirosław <marcin(at)mejor(dot)pl>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Creating index on different tablespace and its temp files
Date: 2010-10-12 08:42:33
Message-ID: 4CB41F79.4000307@mejor.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

W dniu 11.10.2010 15:47, Tom Lane pisze:
> Actually they're spread semi-randomly across all available tablespaces.
>
> IIRC there's a parameter you can set to control which tablespaces are
> used for temp files, if you care.

I'm afraid that temporary files are only created in one tablespace, the
default for database (or the same which is choosed for table). Maybe is
this something interested for "performance side of pg"?:)
Thanks for reply and regards!
Marcin

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Rebecca Cooper 2010-10-12 15:28:04 NonNullValue() error in 8.4
Previous Message Rick Shory 2010-10-11 16:38:51 pass-through query crash using MSAccess front-end