| From: | Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Max File size per Table (1G limit??) |
| Date: | 2007-09-06 04:00:21 |
| Message-ID: | 1189051221.17792.43.camel@neuromancer.home.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 2007-09-04 at 00:51 -0400, Tom Lane wrote:
> Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com> writes:
> > I just browsed to my $PGDATA location and noticed that there are some
> > tables which has ending of .1
>
> TFM has some useful background knowledge for that sort of thing:
> http://www.postgresql.org/docs/8.2/static/storage.html
>
Thanks for the pointers. I now understand it a _bit_ better.
BTW, besides the reason for compatibility for filesystems, does this
give the ability for PG to only read through the file which has the data
instead of transversing from main to .1 to .2 etc??
Stupid question maybe..
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ow Mun Heng | 2007-09-06 04:22:51 | Column as arrays.. more efficient than columns? |
| Previous Message | Alvaro Herrera | 2007-09-06 03:22:40 | Re: Querying database for table pk - better way? |