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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
