"Rainer Mager" <rainer@xxxxxxxxxx> writes: >> From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] >> Hmm ... it's pretty unusual to see the index fetch portion of a bitmap >> scan take the bulk of the runtime. Usually that part is fast and where >> the pain comes is in fetching from the heap. I wonder whether that >> index has become bloated. How big are the table and the index >> physically? (Look at pg_class.relpages, or if you want a really >> accurate number try pg_relation_size().) > Can you give me some more info on how to look at these stats? Since you've got 8.3 it's easy: select pg_relation_size('tablename') (or indexname). The result is in bytes, so you might want to divide by 1K or 1M to keep the number readable. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
