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