On 19t of January, Heikki Linnakangas committed patch:
Make pg_relation_size() and friends return NULL if the object doesn't exist. That avoids errors when the functions are used in queries like "SELECT pg_relation_size(oid) FROM pg_class", and a table is dropped concurrently. Phil Sorber
This patch on its own is not very visible, but it nicely solves the problem that I showed, and tried to fix in previous post.
Unfortunately – my fix was not really a fix – it just made the window of opportunity for the problem smaller.
But, thanks to Phils patch, the window is now closed, as we can get all sizes without exceptions.
Example of usage. Previously we had:
$ SELECT pg_relation_size(423536); ERROR: could NOT OPEN relation WITH OID 423536
but now, it gets me:
$ SELECT pg_relation_size(423536); pg_relation_size ────────────────── [NULL] (1 ROW)
Of course querying the data by name will still fail:
$ SELECT pg_relation_size('non_existing_table'); ERROR: relation "non_existing_table" does NOT exist LINE 1: SELECT pg_relation_size('non_existing_table'); ^
But query like:
SELECT oid::regclass, pg_relation_size(oid) FROM pg_class;
will work fine, without errors now.