Re: pg_tblspc and fsm files - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_tblspc and fsm files
Date
Msg-id 20036.1445979345@sss.pgh.pa.us
Whole thread Raw
In response to pg_tblspc and fsm files  (Mark Steben <mark.steben@drivedominion.com>)
List 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 by date:

Previous
From: Mark Steben
Date:
Subject: pg_tblspc and fsm files
Next
From: Vladimir Borodin
Date:
Subject: Re: Replication slots and isolation levels