| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | "Joseph M(dot) Day" <jday(at)gisolutions(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Linux Filesystem for PG |
| Date: | 2005-03-28 06:46:18 |
| Message-ID: | 20050328064617.GA66681@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Mar 28, 2005 at 12:29:13AM -0600, Joseph M. Day wrote:
> Can anyone recemmend a filesystem to use for Postgres. I currently have
> one table that has 80 mil rows, and will take roughly 8GB of space
> without indexing. Obviously EXT3 will die for a file size this large.
From the "Database Physical Storage" chapter in the 8.0 documentation:
When a table or index exceeds 1Gb, it is divided into gigabyte-sized
segments. The first segment's file name is the same as the
filenode; subsequent segments are named filenode.1, filenode.2,
etc. This arrangement avoids problems on platforms that have
file size limitations.
http://www.postgresql.org/docs/8.0/interactive/storage.html
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2005-03-28 07:06:17 | Re: Linux Filesystem for PG |
| Previous Message | Joseph M. Day | 2005-03-28 06:29:13 | Linux Filesystem for PG |