Hello Tom,
Thank you for you fast answer.
> What PG version is this, and what do you have sort_mem set to?
I am running 8.1.1 on Windows Server 2003 web edition.
Regarding "Memor" these two values are the onliest that are set:
shared_buffers = 1000 # min 16 or max_connections*2, 8KB
each
#temp_buffers = 40000 # min 100, 8KB each
#max_prepared_transactions = 5 # can be 0 or more
# note: increasing max_prepared_transactions costs ~600 bytes of shared
memory
# per transaction slot, plus lock space (see max_locks_per_transaction).
work_mem = 650240 # min 64, size in KB
...
> Increasing sort_mem to a few hundred meg should help, assuming the
> server can spare that much RAM.
Maybe decreasing work_mem to 50000 and setting sort_mem to 600000 would
help.
But where can I find the sort_mem? In postgresql.conf is nothing with that
keyword :-(
> There are no bitmap indexes in Postgres...
The index is using "USING btree", I thought it was a kind of bitmap index.
But I think it is a binary tree then :-)
Thank you,
Christian