Skip site navigation (1) Skip section navigation (2)

Re: Temporary files directory

From: Stefan Huber <schweinsaug(at)crosswinds(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Temporary files directory
Date: 2001-01-24 10:13:23
Message-ID: 5.0.2.1.0.20010124111012.00af0838@pop.crosswinds.net (view raw or flat)
Thread:
Lists: pgsql-admin
>Is it possible to tell postgres where to create the temporary files
>(especially during clustering and re-indexing) ?  Since I have very large
>tables, there is not enough space on the same partition to do clsutering.


What we did, was outsourcing the largest files to other partitions, and then applying a link to them. But I don't know, how long this can go well :)

This is at least an temporary solution, maybe there's some more sophisticated possibility.

>Additionally, is it possible to create a database than spans on more than
>one partition or harddisk under Linux ?

Well, that's what links imitate.

Hope that helped, and that there _is_ a better solution to this problem.

Stefan


In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2001-01-24 15:56:52
Subject: Re: forgotten data base superuser password
Previous:From: David WallDate: 2001-01-24 01:30:21
Subject: OID type creates files that don't go away

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group