On Tue, 3 Aug 2004, Marius Andreiana wrote: > I just vacuum analyse'd the database. > > Trying to run this query: > EXPLAIN ANALYSE > select * FROM trans > WHERE query_id NOT IN (select query_id FROM query) > > but it will remain like that forever (cancelled after 30 min). > > My postgresql.conf is the default: > # - Memory - > > shared_buffers = 1000 # min 16, at least max_connections*2, > 8KB each > #sort_mem = 1024 # min 64, size in KB > #vacuum_mem = 8192 # min 1024, size in KB > > Should I adjust something?
Probably sort_mem. It's probably estimating that it can't hash the result into the 1MB of sort_mem so it's probably falling back to some sort of nested execution. ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match