Re: Add TOAST support for more system tables

2023-07-18 Thread Sofia Kopikova
On Mon, Jul 17, 2023 at 06:31:04PM -0400, Tom Lane wrote: Sofia Kopikova writes: This patch adds TOAST support for system tables pg_class, pg_attribute and pg_largeobject_metadata, as they include ACL columns, which may be potentially large in size. We have been around on this topic before

Add TOAST support for more system tables

2023-07-17 Thread Sofia Kopikova
y problems with this feature. First attempt here: https://www.postgresql.org/message-id/1643112264.186902...@f325.i.mail.ru This time I'll do it better -- Sofia Kopikova Postgres Professional: http://www.postgrespro.com The Russian Postgres Company From 6812e6cd47c03e22f953732a24223411d80d6c95 Mon Sep 17 00:

Re: postgres_fdw: using TABLESAMPLE to collect remote sample

2022-02-16 Thread Sofia Kopikova
to SQL query (set it to zero when do_sample is false). Or you may also add do_sample as a parameter to deparseAnalyzeSql, but as for me that’s redundantly.   Stackoverflow: https://stackoverflow.com/questions/7943233/fast-way-to-discover-the-row-count-of-a-table-in-postgresql   -- Sofia Kopikov

[PATCH] Add TOAST support for several system tables

2022-01-25 Thread Sofia Kopikova
ACL's.   The VACUUM FULL bug is detailed here:   http://postgr.es/m/CAPpHfdu3PJUzHpQrvJ5RC9bEX_bZ6LwX52kBpb0EiD_9e3Np5g%40mail.gmail.com   Looking forward to your comments   -- Sofia Kopikova Postgres Professional: http://www.postgrespro.com The Russian Postgres CompanyFrom