Max File size per Table (1G limit??)

From: Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Max File size per Table (1G limit??)
Date: 2007-09-04 03:47:37
Message-ID: 1188877657.28159.49.camel@neuromancer.home.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ow Mun Heng 2007-09-04 03:51:35 Symlinking (specific) tables to different Drives
Previous Message Ow Mun Heng 2007-09-04 03:31:19 Re: Instances where enable_seqscan = false is good