Hi hackers. There is ineresting behavior of some select query mentioned in $subj.
In working db this query takes: real 3m10.219s user 0m0.074s sys 0m0.074s it's interesting that vacuum or analyze or reinex not helpfull, BUT if dump this db and create it again (whith another name mabe, no matter, just for testing) and query the same query on this db, it takes: real 0m6.225s user 0m0.072s sys 0m0.074s (other databases continue running) There is no end of this story! With some time (couple of days for example) this the same query overloads machine on this new test db also! No one working with this db during this time. Works continued only with real working databases. Vacuuming was as usual (every 2 hours without -f and with it at night one time :) : as i said this behavior does not depend on any vacuuming. Have anyone any ideas about this? db=# SELECT version(); version ----------------------------------------------------------------------- PostgreSQL 7.2.2 on i386-portbld-freebsd4.6.1, compiled by GCC 2.95.3 Thanks, Andriy. -- Because strait is the gate, and narrow is the way, which leadeth unto <b>life</b>, and few there be that find it. (MAT 7:7) <b>Ask</b>, and it shall be given you; <b>seek</b>, and ye shall find; <b>knock</b>, and it shall be opened unto you... (MAT 7:14) ANT17-RIPE ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org