Temporary files directory

Поиск
Список
Период
Сортировка
Искать

Temporary files directory

От:
Robert.Farrugia@go.com.mt
Дата:
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.

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

Thanks
Robert

Re: Temporary files directory

От:
Stefan Huber <schweinsaug@crosswinds.net>
Дата:

>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

FAQ