I know you can't do much with this information, but maybe you can help me acquire the information that is needed. This started in 8.4 and trying to figure it out Fedora 12, Postgres 8.4.4 with slony. Although I don't see any panics or errors other then these Warnings, but I did see a dead lock the other day and so I need to start diving into this and try to figure out what is going on. Thanks for your pointers on how to troubleshoot this 2011-03-12 03:35:30 PST WARNING: pgstat wait timeout 2011-03-12 03:35:35 PST WARNING: pgstat wait timeout 2011-03-12 03:35:46 PST WARNING: pgstat wait timeout -bash-4.0$ ulimit -a core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited scheduling priority (-e) 0 file size (blocks, -f) unlimited pending signals (-i) 258410 max locked memory (kbytes, -l) 64 max memory size (kbytes, -m) unlimited open files (-n) 1024 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 real-time priority (-r) 0 stack size (kbytes, -s) 10240 cpu time (seconds, -t) unlimited max user processes (-u) 1024 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited This happens for a decent amount of time each time it happens. 3am, 9pm, 10pm etc. Thanks Tory -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
