Re: Tablespace files deleted automatically.

On Fri, Oct 14, 2011 at 8:19 PM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
> 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.

Also it does not seem clear whether we are talking about a performance
issue (what this ML is about) or a bug (lost data).

Kind regards

robert

--
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/