| From: | "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com> |
|---|---|
| To: | "Gauri Kanekar" <meetgaurikanekar(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Replication Syatem |
| Date: | 2008-04-30 13:36:12 |
| Message-ID: | 2e78013d0804300636x55f2e293n6f729d935a7490f9@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Please keep list in the loop.
On Wed, Apr 30, 2008 at 6:45 PM, Gauri Kanekar
<meetgaurikanekar(at)gmail(dot)com> wrote:
> Hi,
> We have recreated the indices with fillfactor set to 80, which has improved HOT
> a little,
Wait. Did you say, you recreated the indexes with fill factor ? That's
no help for HOT. You need to recreate the TABLEs with a fill factor.
And as Heikki pointed out, you need to dump and reload, just altering
the table won't affect the current data.
Thanks,
Pavan
--
Pavan Deolasee
EnterpriseDB http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-04-30 14:43:11 | Re: Understanding histograms |
| Previous Message | Heikki Linnakangas | 2008-04-30 13:35:29 | Re: Replication Syatem |