Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Heavy write activity on first vacuum of fresh TOAST data
- From: Simon Riggs <simon(at)2ndquadrant(dot)com>
- To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Heavy write activity on first vacuum of fresh TOAST data
- Date: Thu, 13 Dec 2007 16:11:23 +0000
On Thu, 2007-12-13 at 09:46 -0600, Kevin Grittner wrote: > The data was inserted through a Java program using a prepared > statement with no indexes on the table. The primary key was then > added, and now I've started a vacuum. The new table wound up being > the first big table vacuumed, and I noticed something odd. Even > though there have been no rollbacks, updates, or deletes on this > table, the vacuum is writing as much as it is reading while dealing > with the TOAST data. Writing hint bits. Annoying isn't it? :-( -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com
- Follow-Ups:
- Re: Heavy write activity on first vacuum of fresh TOASTa
- From: Matthew
- Re: Heavy write activity on first vacuum of fresh TOAST data
- From: Kevin Grittner
- Re: Heavy write activity on first vacuum of fresh TOAST data
- From: Kevin Grittner
- Re: Heavy write activity on first vacuum of fresh TOASTa
- References:
- Heavy write activity on first vacuum of fresh TOAST data
- From: Kevin Grittner
- Heavy write activity on first vacuum of fresh TOAST data
- Prev by Date: Heavy write activity on first vacuum of fresh TOAST data
- Next by Date: Re: Limited performance on multi core server
- Previous by thread: Heavy write activity on first vacuum of fresh TOAST data
- Next by thread: Re: Heavy write activity on first vacuum of fresh TOAST data
- Indexes: