Re: Partitioning, Identity and Uniqueness (given pg 16 changes)

2024-02-19 Thread Ketan Popat
> > 1) Is my attempt to improve performance of insert AND (as the number of > sources goes up, as it has) querying which is invariably by id but it is > easy to include "and src = x" in the majority of usage (the other common > case is to query across all sources, asking for a set is unusual) a > r

Can one call pg_total_relation_size over foreign data wrapper?

2022-01-31 Thread Ketan Popat
Hi Team, Can one call pg_total_relation_size over foreign data wrapper? Problem statement - I need to connect to 100s of databases over foreign data wrapper to collect the size of each table. As a part of that I have to use pg_total_relation_size over foreign data wrappers. Alternatively, I woul