pg_am access in simple transaction?

Поиск
Список
Период
Сортировка
От pinker
Тема pg_am access in simple transaction?
Дата
Msg-id 1480077631040-5931974.post@n3.nabble.com
обсуждение исходный текст
Ответы Re: pg_am access in simple transaction?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: pg_am access in simple transaction?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi,
I'm doing simple tests with lsof on data catalog with bash script:

#!/bin/bash
for i in {0..2000}
do
    psql -U postgres -c '*BEGIN; select pg_sleep(30); COMMIT*'&
done

and i measure number of open files and what files are affected by specific
command.
Lsof has shown me that the only file that was open during this test was:
data/base/13328/2601, which is pg_catalog table pg_am.

Why postgres opens a table that stores information about relation (index)
access methods, while none index evidently is in use?








--
View this message in context: http://postgresql.nabble.com/pg-am-access-in-simple-transaction-tp5931974.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


В списке pgsql-general по дате отправления:

Предыдущее
От: Achilleas Mantzios
Дата:
Сообщение: Re: pg_dump system catalog
Следующее
От: Job
Дата:
Сообщение: Replicating hundreds of thousandw of rows