it even further? This is an overloaded system to start with,
so I'm being fairly conservative with what I change.
thanks,
janine
On Jun 3, 2009, at 2:42 PM, Tom Lane wrote:
Janine Sisk writes:
I've been Googling for SQL tuning help for Postgres but the pickings
have been rath
do so.
Thanks!
janine
On Jun 3, 2009, at 2:42 PM, Tom Lane wrote:
Janine Sisk writes:
I've been Googling for SQL tuning help for Postgres but the pickings
have been rather slim. Maybe I'm using the wrong search terms. I'm
trying to improve the performance of the followin
ate (cost=10.77..10.78 rows=1 width=0)
(actual time=0.051..0.053 rows=1 loops=4159)
-> Index Scan using cr_revisions_item_id_idx
on cr_revisions (cost=0.00..10.77 rows=2 width=0) (actual
time=0.019..0.024 rows=1 loops=4159)
Index Cond: (item_id = $0)
To
