Re: pg_toast oid limits - Mailing list pgsql-admin

From David G. Johnston
Subject Re: pg_toast oid limits
Date
Msg-id CAKFQuwbPOhpUjCmnMWuNAyGZ--jp8LdLwJp+ee_hA+2Qx6Q=5A@mail.gmail.com
Whole thread Raw
In response to Re: pg_toast oid limits  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: pg_toast oid limits  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-admin
On Wed, Oct 26, 2016 at 12:05 PM, Joshua D. Drake <jd@commandprompt.com> wrote:
On 10/26/2016 11:58 AM, Natalie Wenz wrote:

What I was reading, for reference:
https://wiki.postgresql.org/wiki/TOAST
http://osdir.com/ml/postgresql-pgsql-hackers/2015-01/msg01901.html

Also, we are running postgres 9.5.4.

oids are used per relation not per row.

​While your conclusion about rows/widths may​
 
​be accurate I'm missing something if you are correct in stating the above.

Each TOAST table has an associated OID but within that table every VALUE (which could mean multiple per record) has an OID and a Sequence Number which combined comprise a PK.  Natalie's line of thinking seems to have some merit even if I don't know how to answer the question at hand.

David J.

pgsql-admin by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: pg_toast oid limits
Next
From: Tom Lane
Date:
Subject: Re: pg_toast oid limits