On Fri, Oct 14, 2011 at 8:19 PM, Josh Berkus <josh@agliodbs.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/