From: Josh Berkus <josh@agliodbs.com>
To: pgsql-performance@postgresql.org
Subject: Re: Tablespace files deleted automatically.
Date: Fri, 14 Oct 2011 11:19:38 -0700
Message-ID: <4E987D3A.9030309@agliodbs.com> (raw)
In-Reply-To: <D0124DE0373A744CA8192AFA82C8311707BE684B@mail-4.tvm.nestgroup.net>
References: <D0124DE0373A744CA8192AFA82C8311707BE684B@mail-4.tvm.nestgroup.net>
Vishnu,
> I am using PostgreSQL 8.4 in windows. I have created a database and
> some tables on it. Also created a table space and some tables in it. My
> application inserts data into these tables in every second. The
> application is a continuous running application. My issue is that after
> a 20-30 days continuous run ( Machine logged off 2 times), some of the
> files in the \16384 folder of newly created table space are dropped
> automatically. Can you tell me the reason for this.? How can we
> recover from this?
PostgreSQL creates and deletes files all the time. I don't understand
why this is a problem.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: josh@agliodbs.com
Subject: Re: Tablespace files deleted automatically.
In-Reply-To: <4E987D3A.9030309@agliodbs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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