Re: Creating index on different tablespace and its temp files - Mailing list pgsql-novice

From Marcin Mirosław
Subject Re: Creating index on different tablespace and its temp files
Date
Msg-id 4CB41F79.4000307@mejor.pl
Whole thread Raw
In response to Re: Creating index on different tablespace and its temp files  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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

pgsql-novice by date:

Previous
From: Rick Shory
Date:
Subject: pass-through query crash using MSAccess front-end
Next
From: "Rebecca Cooper"
Date:
Subject: NonNullValue() error in 8.4