Hello,
I saw a few mentions of 'effective_cache_size' parameter. Is this a
new PG 7.4 option? I have PG 7.3.4 and didn't see that parameter in my
postgresql.conf.
Thanks,
Otis
---(end of broadcast)---
TIP 9: the planner will ignore your desire
Hello,
I'm tuning my PostgreSQL DB (7.3.4) and have come across a query that
doesn't use an index I created specially for it, and consequently takes
circa 2 seconds to run. :(
The ugly query looks like this (the important part is really at the
very end - order by piece):
select userinfo1_.id as