Re: pg_relation_size locking - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: pg_relation_size locking
Date
Msg-id 20051213014720.GC24605@surnet.cl
Whole thread Raw
In response to Re: pg_relation_size locking  (Andreas Pflug <pgadmin@pse-consulting.de>)
Responses Re: pg_relation_size locking  (Andreas Pflug <pgadmin@pse-consulting.de>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Cost-based optimizers
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Different length lines in COPY CSV