On Sat, Feb 2, 2013 at 2:33 PM, Jeff Janes <jeff.ja...@gmail.com> wrote: > On Sat, Jan 5, 2013 at 8:03 PM, Tomas Vondra <t...@fuzzy.cz> wrote: >> On 3.1.2013 20:33, Magnus Hagander wrote: >>> >>> Yeah, +1 for a separate directory not in global. >> >> OK, I moved the files from "global/stat" to "stat". > > This has a warning: > > pgstat.c:5132: warning: 'pgstat_write_statsfile_needed' was used with > no prototype before its definition > > I plan to do some performance testing, but that will take a while so I > wanted to post this before I get distracted.
Running "vacuumdb -a" on a cluster with 1000 db with 200 tables (x serial primary key) in each, I get log messages like this: last_statwrite 23682-06-18 22:36:52.960194-07 is later than collector's time 2013-02-03 12:49:19.700629-08 for db 16387 Note the bizarre year in the first time stamp. If it matters, I got this after shutting down the cluster, blowing away $DATA/stat/*, then restarting it and invoking vacuumdb. Cheers, Jeff -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
