Re: strange disappearence of postgres file

Harald Armin Massa wrote:
> Hello QuingQing,
>
> > What is your file system, NTFS or FAT32? Is that table newly created?
>
> File System is NTFS. That table was created with database installation,
> which was short after after release of PostgreSQL 8.0 - so that database was
> in use for > 9 months. That table is a central table of the application, and
> is used very often ... the application was running for the whole 9 months :)

How many database-wide vacuums did you run during these 9 months?  I'm
smelling transaction Id wraparound in pg_class or some other system
catalog.

This has been known to happen.  Please see the archives.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support