Обсуждение: pg_tblspc and fsm files

Поиск
Список
Период
Сортировка

pg_tblspc and fsm files

От
Mark Steben
Дата:
Good afternoon,

We are running postgres 9.2.12

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)
 
I search the directory referenced and confirm that, indeed, there is no fsm file that resides there.
Neither is there an fsm file in the database's base directory.  However, we have other indexes built in non-default tablespaces and I find no fsm file there either. 

I realize that strace is not a postgres command.  Is this something that needs to be fixed or can I ignore?

Thank you,
--
Mark Steben
 Database Administrator
@utoRevenue | Autobase 
  CRM division of Dominion Dealer Solutions 
95D Ashley Ave.
West Springfield, MA 01089

t: 413.327-3045
f: 413.383-9567

www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
 www.drivedominion.com





Re: pg_tblspc and fsm files

От
Tom Lane
Дата:
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