Re: Is a limitation for the number of large objects that can be stored in a PostgreSQL database? - Mailing list pgsql-general

From Doug McNaught
Subject Re: Is a limitation for the number of large objects that can be stored in a PostgreSQL database?
Date
Msg-id m3llziezts.fsf@varsoon.wireboard.com
Whole thread Raw
In response to Is a limitation for the number of large objects that can be stored in a PostgreSQL database?  (u15074 <u15074@hs-harz.de>)
List pgsql-general
u15074 <u15074@hs-harz.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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Catching errors in pl/pgsql
Next
From: Tom Lane
Date:
Subject: Re: Redefining LIKE operator