pg_tblspc and fsm files

From: Mark Steben <mark(dot)steben(at)drivedominion(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: pg_tblspc and fsm files
Date: 2015-10-27 18:08:46
Message-ID: CADyzmyxuLm34_4p=3XUsF2u-T6Ax9VNoMJM1AD9Zi_b-1ofxxA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 <http://www.autorevenue.com/> | Autobase
<http://www.autobase.net/>
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 <http://www.autorevenue.com/>

<http://autobasedigital.net/marketing/DD12_sig.jpg>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2015-10-27 20:55:45 Re: pg_tblspc and fsm files
Previous Message Vladimir Borodin 2015-10-27 16:45:58 Replication slots and isolation levels