Re: Tablespace files deleted automatically. - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Tablespace files deleted automatically.
Date
Msg-id 4E987D3A.9030309@agliodbs.com
Whole thread Raw
In response to Tablespace files deleted automatically.  ("Vishnu S." <vishnu.s@nestgroup.net>)
Responses Re: Tablespace files deleted automatically.
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Arjen van der Meijden
Date:
Subject: Re: SSD options, small database, ZFS
Next
From: Michael Viscuso
Date:
Subject: Re: Slow query when using ORDER BY *and* LIMIT