pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pg_tblspc and fsm files 2+ messages / 2 participants [nested] [flat]
* pg_tblspc and fsm files @ 2015-10-27 18:08 Mark Steben <mark.steben@drivedominion.com> 2015-10-27 20:55 ` Re: pg_tblspc and fsm files Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 2+ messages in thread From: Mark Steben @ 2015-10-27 18:08 UTC (permalink / raw) To: 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; ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pg_tblspc and fsm files 2015-10-27 18:08 pg_tblspc and fsm files Mark Steben <mark.steben@drivedominion.com> @ 2015-10-27 20:55 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2015-10-27 20:55 UTC (permalink / raw) To: Mark Steben <mark.steben@drivedominion.com>; +Cc: 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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2015-10-27 20:55 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2015-10-27 18:08 pg_tblspc and fsm files Mark Steben <mark.steben@drivedominion.com> 2015-10-27 20:55 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox