| From: | Craig Ringer <ringerc(at)ringerc(dot)id(dot)au> |
|---|---|
| To: | Andreas Karlsson <andreas(at)proxel(dot)se> |
| Cc: | dmigowski(at)ikoffice(dot)de, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #6325: Useless Index updates |
| Date: | 2011-12-05 00:25:31 |
| Message-ID: | 4EDC0F7B.7020602@ringerc.id.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-general |
On 12/05/2011 08:16 AM, Andreas Karlsson wrote:
> On 2011-12-04 15:02, Craig Ringer wrote:
>> - The index isn't always updated. Check out HOT (introduced in 8.4, the
>> release after your current one) which reduces unnecessary index
>> updates in cases where the old and new row can fit on the same
>> heap page.
>
> Minor correction: HOT was introduced in 8.3.
>
> http://www.postgresql.org/docs/9.1/static/release-8-3.html
Whoops, thanks. In that case the OP is already getting the benefit of
reduced index updates as much as is possible with PostgreSQL's MVCC design.
--
Craig Ringer
| From | Date | Subject | |
|---|---|---|---|
| Next Message | maxim.boguk | 2011-12-05 02:35:36 | BUG #6326: SELECT ARRAY(SELECT ...) syntax and array[] results doesn't work |
| Previous Message | Andreas Karlsson | 2011-12-05 00:16:54 | Re: BUG #6325: Useless Index updates |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Maxim Boguk | 2011-12-05 03:28:55 | WITH and WITH RECURSIVE in single query |
| Previous Message | Andreas Karlsson | 2011-12-05 00:16:54 | Re: BUG #6325: Useless Index updates |