Re: [GENERAL] Large objects oids

2008-06-10 Thread Tom Lane
David Wall <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Yup, and in practice you'd better have a lot less than that or assigning >> a new OID might take a long time. > What's a rough estimate of "a lot less"? Are we talking 2 billion, 3 > billion, 1 billion? It's difficult to say --- the as

Re: [GENERAL] Large objects oids

2008-06-10 Thread David Wall
Tom Lane wrote: David Wall <[EMAIL PROTECTED]> writes: Since large objects use OIDs, does PG 8.3 have a limit of 4 billion large objects across all of my various tables Yup, and in practice you'd better have a lot less than that or assigning a new OID might take a long time. What

Re: [GENERAL] Large objects oids

2008-06-10 Thread Tom Lane
David Wall <[EMAIL PROTECTED]> writes: > Since large objects use OIDs, does PG 8.3 have a limit of 4 billion > large objects across all of my various tables Yup, and in practice you'd better have a lot less than that or assigning a new OID might take a long time. > (actually, I presume OIDs > a

[GENERAL] Large objects oids

2008-06-10 Thread David Wall
Since large objects use OIDs, does PG 8.3 have a limit of 4 billion large objects across all of my various tables (actually, I presume OIDs are used elsewhere besides just large objects)? Is there any plan on allowing large objects to support more than 2GB? As data gets larger and larger, I c