Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Reduction in WAL for UPDATEs
- From: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
- To: "Florian G. Pflug" <fgp(at)phlo(dot)org>
- Cc: "Kenneth Marshall" <ktm(at)rice(dot)edu>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-hackers(at)postgresql(dot)org>
- Subject: Re: Reduction in WAL for UPDATEs
- Date: Wed, 28 Mar 2007 15:55:46 +0100
- Message-id: <1175093747(dot)4386(dot)332(dot)camel(at)silverbirch(dot)site>
On Wed, 2007-03-28 at 15:51 +0200, Florian G. Pflug wrote: > BTW, the "COMMIT NOWAIT" feature Simon Riggs proposed should provide > a huge speedup too, since dspam runs one transaction for each token > it has to update. I've switched to doing the COMMIT NOWAIT as a priority now, but do plan to do both for 8.3. -- Simon Riggs EnterpriseDB http://www.enterprisedb.com
- References:
- Reduction in WAL for UPDATEs
- From: Simon Riggs
- Re: Reduction in WAL for UPDATEs
- From: Tom Lane
- Re: Reduction in WAL for UPDATEs
- From: Simon Riggs
- Re: Reduction in WAL for UPDATEs
- From: Kenneth Marshall
- Re: Reduction in WAL for UPDATEs
- From: Florian G. Pflug
- Reduction in WAL for UPDATEs
- Prev by Date: ECPG threads test
- Next by Date: Re: Reduction in WAL for UPDATEs
- Previous by thread: Re: Reduction in WAL for UPDATEs
- Next by thread: Re: Reduction in WAL for UPDATEs
- Indexes: