Re: [BUGS] BUG #6325: Useless Index updates

2011-12-06 Thread Daniel Migowski
#6325: Useless Index updates On 12/04/2011 08:54 PM, dmigow...@ikoffice.de wrote: > The following bug has been logged on the website: > > Bug reference: 6325 > Logged by: Daniel Migowski > Email address: dmigow...@ikoffice.de > PostgreSQL version: 8.3.16 > Oper

Re: [BUGS] BUG #6325: Useless Index updates

2011-12-04 Thread Craig Ringer
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 pag

Re: [BUGS] BUG #6325: Useless Index updates

2011-12-04 Thread Andreas Karlsson
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.

Re: [BUGS] BUG #6325: Useless Index updates

2011-12-04 Thread hubert depesz lubaczewski
On Sun, Dec 04, 2011 at 12:54:25PM +, dmigow...@ikoffice.de wrote: > It seems that an update to a row in a table always removes the element from > an index and adds it again. Wouldn't it be faster to check for equality of > the index parameters in the OLD and NEW record first? http://www.depe

Re: [BUGS] BUG #6325: Useless Index updates

2011-12-04 Thread Craig Ringer
On 12/04/2011 08:54 PM, dmigow...@ikoffice.de wrote: The following bug has been logged on the website: Bug reference: 6325 Logged by: Daniel Migowski Email address: dmigow...@ikoffice.de PostgreSQL version: 8.3.16 Operating system: Linux Description: It seems that an update

[BUGS] BUG #6325: Useless Index updates

2011-12-04 Thread dmigowski
The following bug has been logged on the website: Bug reference: 6325 Logged by: Daniel Migowski Email address: dmigow...@ikoffice.de PostgreSQL version: 8.3.16 Operating system: Linux Description: It seems that an update to a row in a table always removes the element