Re: is PG able to handle a >500 GB Database?

From: Florent Guillaume <efgeor(at)noos(dot)fr>
To: "Martin A(dot) Marques" <martin(at)math(dot)unl(dot)edu(dot)ar>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: is PG able to handle a >500 GB Database?
Date: 2001-01-22 20:56:04
Message-ID: 20010122215604.A18878@twin.efge.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> > select recordid from t1 where oid = $lastoid;
> > Because the last select could return several lines.
>
> Shouldn't! oids are unique over the whole database server (I'm right on
> this?) So you should have only one or non.

Well, no, that's the point of this whole discussion. If you give it
enough time, oids can wrap around, which apparently doesn't affect the
functionning of the database but application that depend on unique oids
could get hosed.

Yes, the documentation is wrong.

Florent

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2001-01-22 21:00:25 Re: Arrays advanced usage
Previous Message Peter Mount 2001-01-22 20:40:53 Re: postgres memory management