Re: big tables with lots-o-rows

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: big tables with lots-o-rows
Дата
Msg-id 2939.1057070160@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: big tables with lots-o-rows  (Michiel Lange <michiel@minas.demon.nl>)
Список pgsql-admin
Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk> writes:
> On Tue, 1 Jul 2003, Tom Lane wrote:
>> None of that has the slightest relevance to Postgres, however, since we
>> always split large tables into gigabyte-sized segment files.

> I was under the impression that largefile would make the DB store data
> in larger files, where appropriate,

It does not.  (There is a manual compile-time option to turn off the
splitting, but the non-split code paths haven't been exercised in years,
and quite honestly I wouldn't trust them.)

> For example, running out of inodes is also reported as out-of-space.

Excellent thought ...

            regards, tom lane

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

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: Max file size
Следующее
От: weigelt@metux.de
Дата:
Сообщение: Re: replication/redundancy