Request a Demo
Home   >   mailing lists

Re: Improve Query - Mailing list pgsql-performance

From Heikki Linnakangas
Subject Re: Improve Query
Date
Msg-id 4A1D73FC.8060608@enterprisedb.com
Whole thread Raw
In response to Re: Improve Query  (Zach Calvert <zachcalvert@hemerasoftware.com>)
List pgsql-performance
Tree view 
Zach Calvert wrote:
> Still getting a seq scan after doing vacuum analyze.  Any other ideas?

Try CLUSTERing the table on the (leaderboardid, active, score) index.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

pgsql-performance by date:

Previous
From: Zach Calvert
Date:
Subject: Re: Improve Query
Next
From: Alan McKay
Date:
Subject: Postgres Clustering