Re: Is a limitation for the number of large objects that can be stored in a PostgreSQL database?

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: u15074 <u15074(at)hs-harz(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Is a limitation for the number of large objects that can be stored in a PostgreSQL database?
Date: 2003-03-14 15:24:15
Message-ID: m3llziezts.fsf@varsoon.wireboard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

u15074 <u15074(at)hs-harz(dot)de> writes:

> I want to store a lot of binary data (but not so big) as large
> objects in a PostgreSQl database. Since the large objects are
> referenced by an identifier of type oid, which is of type unsigned
> int (right?), my question is, if the number of large objects that
> can be stored in the database is limited by the range of the oid?

Well, yes. But that's more than 4 billion objects--you're much more
likely to run out of disk space before you run out of OIDs.

-Doug

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-03-14 15:44:30 Re: Redefining LIKE operator
Previous Message Richard Huxton 2003-03-14 15:16:55 Re: Catching errors in pl/pgsql