Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow indexscan - Mailing list pgsql-performance

From Tom Lane
Subject Re: Slow indexscan
Date
Msg-id 18952.1182355276@sss.pgh.pa.us
Whole thread Raw
In response to Re: Slow indexscan  ("Mikko Partio" <mpartio@gmail.com>)
Responses Re: Slow indexscan  ("Mikko Partio" <mpartio@gmail.com>)
List pgsql-performance
Tree view 
"Mikko Partio" <mpartio@gmail.com> writes:
> Adding a new index does not speed up the query (although the planner decides
> to use the index):

Hm.  Lots of dead rows maybe?  What's your vacuuming policy?

            regards, tom lane

pgsql-performance by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Slow indexscan
Next
From: "Campbell, Lance"
Date:
Subject: Re: Volunteer to build a configuration tool