Re: big tables with lots-o-rows - Mailing list pgsql-admin

From Tom Lane
Subject Re: big tables with lots-o-rows
Date
Msg-id 2939.1057070160@sss.pgh.pa.us
Whole thread Raw
In response to Re: big tables with lots-o-rows  (Michiel Lange <michiel@minas.demon.nl>)
List 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 by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Max file size
Next
From: weigelt@metux.de
Date:
Subject: Re: replication/redundancy