Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.



---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
       message can get through to the mailing list cleanly

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux