Re: Tablespace files deleted automatically.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux