Re: Disk filling, CPU filling, renegade inserts and deletes?
| От | Richard Plotkin |
|---|---|
| Тема | Re: Disk filling, CPU filling, renegade inserts and deletes? |
| Дата | |
| Msg-id | 2a9467bc6e6dab5d997427c4ef6158e3@richardplotkin.com обсуждение исходный текст |
| Ответ на | Re: Disk filling, CPU filling, renegade inserts and deletes? (Richard Plotkin <richard@richardplotkin.com>) |
| Ответы |
Re: Disk filling, CPU filling, renegade inserts and deletes?
Re: Disk filling, CPU filling, renegade inserts and deletes? |
| Список | pgsql-performance |
If anybody has additional advice on this problem, I would really, really appreciate it... I updated postgres to 8.0.2, am running vacuumdb -faz every 3 hours, and 50 minutes after a vacuum the CPU usage still skyrocketed, and the disk started filling. This time, there is only a single file that is spanning multiple GB, but running oid2name again returns no result on the oid or filenode. With the increased vacuuming, fixed temp tables, etc., I really am at a loss for what's happening, and could really use some additional help. Thank you, Richard
В списке pgsql-performance по дате отправления: