I too have used a symlink for some time (years) to put temp onto dedicated disks without any problems. I am not sure if 8.3 is different but I symlink the directory: base/pgsql_tmp Aaron Thul http://www.chasingnuts.com On Fri, Oct 31, 2008 at 8:11 AM, Sam Mason <sam@xxxxxxxxxxxxx> wrote: > On Fri, Oct 31, 2008 at 09:01:29AM +0100, Christian Schrrrder wrote: >> So I would like >> to use a faster disk for these temporary files, too, but I could not >> find where the temporary files are located. Is there a separate >> directory? I have found a "pgsql_tmp" directory inside of the database >> directories ("base/<oid>/pgsql_tmp"). Is this what I'm looking for? > > Yes, I believe it's accepted practice to replace this directory with a > symlink. I've done this before and it's behaved as I'd expect. > > > Sam > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
