| From: | "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com> |
|---|---|
| To: | "Gauri Kanekar" <meetgaurikanekar(at)gmail(dot)com> |
| Cc: | "Greg Smith" <gsmith(at)gregsmith(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Replication Syatem |
| Date: | 2008-04-29 13:09:39 |
| Message-ID: | 2e78013d0804290609k3bd2aa94q8c6b1c9763e2355a@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, Apr 29, 2008 at 6:29 PM, Gauri Kanekar
<meetgaurikanekar(at)gmail(dot)com> wrote:
>
>
> Found that the size increased gradually. Is HOT working over here ??
> Guide me if im doing something wrong.
>
You have chosen a bad case for HOT. Since you are repeatedly updating
the same set of rows, the dead space created in the first step is the
blocks which are not touched in the subsequent updates. Is this a real
scenario or are you just testing ? If its just for testing, I would
suggest updating different sets of rows in each step and then check.
Thanks,
Pavan
--
Pavan Deolasee
EnterpriseDB http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gauri Kanekar | 2008-04-29 13:12:40 | Re: Replication Syatem |
| Previous Message | Alvaro Herrera | 2008-04-29 13:03:14 | Re: Replication Syatem |