Re: Heavy write activity on first vacuum of fresh TOAST data

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: "Simon Riggs" <simon(at)2ndquadrant(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Heavy write activity on first vacuum of fresh TOAST data
Date: 2007-12-13 16:35:21
Message-ID: 13267.1197563721@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> writes:
> ... although to a naive user it's not clear what
> is known at vacuum time that the INSERT into the empty table
> couldn't have inferred.

The fact that the INSERT actually committed.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2007-12-13 16:39:47 Re: Heavy write activity on first vacuum of fresh TOAST data
Previous Message Kevin Grittner 2007-12-13 16:26:58 Re: Heavy write activity on first vacuum of fresh TOAST data