OS File Size > 1GB

Поиск
Список
Период
Сортировка
От Chris Ruprecht
Тема OS File Size > 1GB
Дата
Msg-id 200207251250.30219.chrup@earthlink.net
обсуждение исходный текст
Ответы Re: OS File Size > 1GB  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Hi all,

The default size of a Postgres file seems to be 1 GB. I know, I can increase
that by modifying <can't remember what it was I did here - that parameter
which gives you the file size, once you divide it by the blocksize>
My question is: is it safe to do so?
My motivation: I symlink the files across different drives but when postgres
decided to create a new file (.1, .2, .3 ...) they are created in the
data/base/nnnn directory and not where all his little brothers and sisters
live and where they SHOULD be.

Best regards,
Chris

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Maximum Number of Tables in a database
Следующее
От: Mathieu Arnold
Дата:
Сообщение: Re: CREATE TABLE AS ...