Hi I am currently running a vacuum analyse through PgAdmin on a PostgreSQL 8.1.9 database that takes forever without doing anything: no (noticeable) disk activity or (noticeable) CPU activity.
The mesage tab in PgAdmin says: ... Detail: 0 index pages have been deleted, 0 are currently reusable. CPU 0.01s/0.00u sec elapsed 568.16 sec .... and lots of entries looking just like this ( 0 % CPU, > 500 secs). There are no other connections to the database and the machine does not do anything else than me typing this e-mail and playing Metallica MP3's. Could this be because of my Cost-Based Vacuum Delay settings ? vacuum_cost_delay = 200 vacuum_cost_page_hit = 6 #vacuum_cost_page_miss = 10 # 0-10000 credits #vacuum_cost_page_dirty = 20 # 0-10000 credits vacuum_cost_limit = 100 -- Groeten, Joost Kraaijeveld Askesis B.V. Molukkenstraat 14 6524NB Nijmegen tel: 024-3888063 / 06-51855277 fax: 024-3608416 web: www.askesis.nl ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate