Re: pg_relation_size locking

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: pg_relation_size locking
Дата
Msg-id 20051213014720.GC24605@surnet.cl
обсуждение исходный текст
Ответ на Re: pg_relation_size locking  (Andreas Pflug <pgadmin@pse-consulting.de>)
Ответы Re: pg_relation_size locking  (Andreas Pflug <pgadmin@pse-consulting.de>)
Список 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 по дате отправления:

Предыдущее
От: Christopher Kings-Lynne
Дата:
Сообщение: Cost-based optimizers
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: Different length lines in COPY CSV