Earlier posts by Tom Lane indicated that when 32 bits are taken up, you
have to dump/restore your database (actually, you have to do that before
they are all gone).
Gnome calculator shows 2^32 being 4,294,967,296, or roughly 4 billion
transactions. This doesn't really matter in the medium-size database
department (if you get there let me know), but in the higher-end it could
be a problem.
Tom suggested a dump/restore when pg_log got near 1 gig.
Jon
johnnyb6@sdf.lonestar.org
SDF Public Access UNIX System - http://sdf.lonestar.org
On Fri, 8 Jun 2001, Nicolas Huillard wrote:
> > No limit on #transactions before dump/restore
>
> What is that limit ? Is Postgres limited in such way ?
>
> NH
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>