On 10/26/2016 12:18 PM, David G. Johnston wrote:
On Wed, Oct 26, 2016 at 12:05 PM, Joshua D. Drake <jd@xxxxxxxxxxxxxxxxx
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.
Oh that's interesting. I think you are right. That said, the way forward I think is still to partition that out and possibly break up the table.
Sincerely, JD -- Command Prompt, Inc. http://the.postgres.company/ +1-503-667-4564 PostgreSQL Centered full stack support, consulting and development. Everyone appreciates your honesty, until you are honest with them. Unless otherwise stated, opinions are my own. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
