Re: Possible to improve query plan?

From: Kevin Grittner
Subject: Re: Possible to improve query plan?
Date: ,
Msg-id: 4D3DBCED0200002500039B8C@gw.wicourts.gov
(view: Whole thread, Raw)
In response to: Re: Possible to improve query plan?  (Jeremy Palmer)
Responses: Re: Possible to improve query plan?  (Cédric Villemain)
List: pgsql-performance

Tree view

Possible to improve query plan?  (Jeremy Palmer, )
   Re: Possible to improve query plan?  (Andy Colson, )
    Re: Possible to improve query plan?  (Jeremy Palmer, )
   Re: Possible to improve query plan?  ("Ing. Marcos Ortiz Valmaseda", )
    Re: Possible to improve query plan?  (Jeremy Palmer, )
   Re: Possible to improve query plan?  ("Kevin Grittner", )
    Re: Possible to improve query plan?  (Robert Haas, )
     Re: Possible to improve query plan?  ("Kevin Grittner", )
      Re: Possible to improve query plan?  (Tom Lane, )
       Re: Possible to improve query plan?  ("Kevin Grittner", )
        Re: Possible to improve query plan?  (Jeremy Palmer, )
         Re: Possible to improve query plan?  ("Kevin Grittner", )
          Re: Possible to improve query plan?  (Cédric Villemain, )
         Re: Possible to improve query plan?  ("Kevin Grittner", )
          Re: Possible to improve query plan?  (Jeremy Palmer, )
     Re: Possible to improve query plan?  (Tom Lane, )

Jeremy Palmer <> wrote:

> Kevin I've now clustered the table. And the performance did
> increase quite a bit.

Yeah, that's enough to notice the difference.

> My only question is how often will I need to re-cluster the table,
> because it comes at quite a cost. The setup I'm running will mean
> that 10,000 new rows will be inserted, and 2,500 rows will be
> updated on this table each day.

You're going to see performance drop off as the data fragments.
You'll need to balance the performance against maintenance
down-time.  I would guess, though, that if you have a weekly
maintenance window big enough to handle the CLUSTER, it might be
worth doing it that often.

-Kevin


pgsql-performance by date:

From: Dimi Paun
Date:
Subject: Re: How to use indexes for GROUP BY
From: Cédric Villemain
Date:
Subject: Re: Possible to improve query plan?