On 9/3/07, Ow Mun Heng <Ow.Mun.Heng@xxxxxxx> wrote: > I just browsed to my $PGDATA location and noticed that there are some > tables which has ending of .1 > > # ls -lahS | egrep '(24694|24702|24926)' > -rw------- 1 postgres postgres 1.0G Sep 3 22:56 24694 > -rw------- 1 postgres postgres 1.0G Sep 3 22:52 24702 > -rw------- 1 postgres postgres 1.0G Sep 3 22:58 24926 > -rw------- 1 postgres postgres 800M Sep 3 22:57 24694.1 > -rw------- 1 postgres postgres 161M Sep 3 22:52 24702.1 > -rw------- 1 postgres postgres 12M Sep 3 22:58 24926.1 > > I'm wondering what are these since I've not set up table partitioning > just yet. > > postgres uses datafiles from up to 1GB, if a table has more data than that limit then postgres creates more files. http://www.postgresql.org/docs/8.2/static/storage-file-layout.html -- regards, Jaime Casanova "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe trying to produce bigger and better idiots. So far, the universe is winning." Richard Cook ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
