Re: pg_relation_size locking

Andreas Pflug wrote:
> Alvaro Herrera wrote:
> >
> >The problem with the original coding was that it used the table Oid to
> >look up the file name, which is wrong.  (Test it with a table that has
> >been clustered or an index that has been reindexed.)
> 
> Um, can't test at the moment. The oldcode used pg_class->relfilnode, 
> which delivers "Name of the on-disk file of this relation" according to 
> the docs. What's wrong with that?

Hum, nothing that I can see, but I changed that code precisely because
somebody complained that it didn't work after truncating.  Do you mean
"oldcode" as "the contrib code", or "the initially integrated in backend
code"?

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support