Tena Sakai wrote: > Hi Alvaro, > > I just looked in pg_clog directory and there is > only one file: > -rw------- 1 postgres postgres 24576 Aug 25 20:18 0000 > I saw the same file about 10:30 am and I believe > it was roughly the same size. This is a brand new > installation of 8.3.3. Maybe initdb was executed? That would cause the files to disappear. Of course, so would the data; it would have to be restored from a backup. Note that these files use only 2 bits per transaction, so in 24756 bytes you have enough room to cover 99024 transactions. Furthermore, they always grow in 8192-byte increments. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.
