Re: [BUGS] Problem with planer

[EMAIL PROTECTED] wrote: select ats.id, ap.value from akh_test_suit ats LEFT JOIN akh_properties ap on ap.ID = ats.test_suit_type_id where ats.ID = 472 id | value 472 | 472 ID -- integer value -- text select * from akh_test_suit ats LEFT JOIN akh_properties ap on ap.ID = ats.test_suit_type_id whe

[BUGS] Vacuums and bad process status

I am using PostgreSQL 7.1.2 and I am running into trouble when Vacuuming a very big DB while others are working on the DB: 21640 pts/0SN 0:00 /usr/local/pgsql/bin/psql -c VACUUM VERBOSE ANALYZE -d intranet 21641 ?D 3:05 postgres: postgres intranet [local] VACUUM Status "D"

Re: [BUGS] Vacuums and bad process status

Strange ... The process continued after stopping for a while (and using no CPU time). Sorry, no bug :) Hans ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html