On Tue, 2007-09-04 at 00:51 -0400, Tom Lane wrote: > Ow Mun Heng <Ow.Mun.Heng@xxxxxxx> 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.. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
