[Junaili Lie - Thu at 06:26:09PM -0700] > Hi Bruno, > I followed your suggestion. > The query plan shows that it uses the index (id, person_id). However, > the execution time is still slow. I have to do ctl-C to stop it.
What is the estimate planner cost? > Maybe something is wrong with my postgresql config. > It's running Solaris on dual Opteron, 4GB. > I allocated around 128MB for sorting and more than 80% for > effective_cache_size and shared_buffers = 32768. > Any further ideas is much appreciated. Sounds a bit excessive. Compare with the vanilla configuration, and see what is faster. -- Tobias Brox, +47-91700050 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings