Laszlo Nagy wrote: > Alvaro Herrera wrote: >> Laszlo Nagy wrote: >> >>> PostgreSQL 8.3.5, the system is now stable (uptime > 10 days). >>> PostgreSQL stats collector uses 100% CPU forever: >>> >> >> Could you grab a few stack traces from it and post them? Also possibly >> useful, leave strace running on the pgstat process for a while and post >> the output somewhere. >> > Very interesting results. Before I used 'truss' on the process, it was: > > 78816 pgsql 1 106 0 22400K 7100K CPU6 6 24.2H 99.02% > postgres > > After I started "truss -p 78815" the first message I got was: It was 78816 and you traced 78815? Are you sure the process with 24h of CPU was pgstat? -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
