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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-01-24 15:56:52 | Re: forgotten data base superuser password |
Previous Message | David Wall | 2001-01-24 01:30:21 | OID type creates files that don't go away |