Re: Possible to improve query plan?

Список
Период
Сортировка
От Kevin Grittner
Тема Re: Possible to improve query plan?
Дата
Msg-id 4D3DBCED0200002500039B8C@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: Possible to improve query plan?  (Jeremy Palmer)
Ответы Re: Possible to improve query plan?  (Cédric Villemain)
Список pgsql-performance
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Dimi Paun
Дата:
Сообщение: Re: How to use indexes for GROUP BY
Следующее
От: Cédric Villemain
Дата:
Сообщение: Re: Possible to improve query plan?