Обсуждение: Size limitation for a table under linux ........

Hi,

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.

Thanks,

PEJAC Pascal

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

pejac@altern.org wrote:
>
> Hi,
>
> 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.
>
> Thanks,
>
> PEJAC Pascal
>