Just go ahead and create it. PostgreSQL will split the tables into
multiple files, to avoid the 2GB limitation.
When you do a pg_dump and the file is bigger than 2GB you will also have
a problem. That problem is solved by pipening the output to "gzip" and
possibly "split", if the zipped file is bigger than 2GB.
Poul L. Christiansen
> I want to know if we can create a table > 2 Go under
> linux because linux use ext2 ( and size file is limit to 2Go )
> Why postgresql don't use directly the device like other
> commercial DB ( sybase or oracle can permitt that ). Is it
> more performant ???
> So how can i create table with a size > 2Go under linux
> with postgresql.
> PEJAC Pascal
In response to
pgsql-novice by date
|Next:||From: Gerhard Kroder||Date: 2000-10-18 10:34:04|
|Previous:||From: pejac||Date: 2000-10-18 08:08:11|
|Subject: Size limitation for a table under linux ........|