Re: pg_tblspc and fsm files

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_tblspc and fsm files
Дата
Msg-id 20036.1445979345@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_tblspc and fsm files  (Mark Steben <mark.steben@drivedominion.com>)
Список pgsql-admin
Mark Steben <mark.steben@drivedominion.com> writes:
> I created a new tablespace on a disk different from where the actual
> database resides.  I then create a new index on that tablespace.  While
> troubleshooting a performance issue I run an
> strace and this statement is issued:

> pg_tblspc/883496444/PG_9.2_201204301/883496522/885187893_fsm", O_RDWR) = -1
> ENOENT (No such file or directory)

This is a non-issue.  It's normal for a table or index to not have an FSM
early in its lifespan.

            regards, tom lane


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

Предыдущее
От: Mark Steben
Дата:
Сообщение: pg_tblspc and fsm files
Следующее
От: Vladimir Borodin
Дата:
Сообщение: Re: Replication slots and isolation levels