| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | "Jeremy Palmer" <JPalmer(at)linz(dot)govt(dot)nz> |
| Cc: | "Robert Haas" <robertmhaas(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>, "andy(at)squeakycode(dot)net" <andy(at)squeakycode(dot)net>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: Possible to improve query plan? |
| Date: | 2011-01-24 23:54:53 |
| Message-ID: | 4D3DBCED0200002500039B8C@gw.wicourts.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Jeremy Palmer <JPalmer(at)linz(dot)govt(dot)nz> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2011-01-25 00:01:31 | Re: Possible to improve query plan? |
| Previous Message | Jeremy Palmer | 2011-01-24 21:55:07 | Re: Possible to improve query plan? |