Skip site navigation (1) Skip section navigation (2)

Re: Size limitation for a table under linux ........

From: "Poul L(dot) Christiansen" <poulc(at)cs(dot)auc(dot)dk>
To: pejac(at)altern(dot)org
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Size limitation for a table under linux ........
Date: 2000-10-18 10:11:41
Message-ID: 39ED775D.ADF95534@cs.auc.dk (view raw or flat)
Thread:
Lists: pgsql-novice
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(at)altern(dot)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
>

In response to

pgsql-novice by date

Next:From: Gerhard KroderDate: 2000-10-18 10:34:04
Subject: test,sorry
Previous:From: pejacDate: 2000-10-18 08:08:11
Subject: Size limitation for a table under linux ........

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group