[PERFORM] effective_cache_size in 7.3.4?

2004-09-10 Thread ogjunk-pgjedan
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

[PERFORM] Costly Sort Key on indexed timestamp column

2004-09-09 Thread ogjunk-pgjedan
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