Re: pg_tblspc and fsm files

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mark Steben <mark(dot)steben(at)drivedominion(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: pg_tblspc and fsm files
Date: 2015-10-27 20:55:45
Message-ID: 20036.1445979345@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Mark Steben <mark(dot)steben(at)drivedominion(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Vladimir Borodin 2015-10-29 08:42:57 Re: [ADMIN] Replication slots and isolation levels
Previous Message Mark Steben 2015-10-27 18:08:46 pg_tblspc and fsm files