On Fri, Oct 14, 2011 at 8:19 PM, Josh Berkus <josh@xxxxxxxxxxxx> 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/ -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
