Postgres Pro
Downloads
Home   >   mailing lists

Re: Heavy write activity on first vacuum of fresh TOAST data - Mailing list pgsql-performance

From Tom Lane
Subject Re: Heavy write activity on first vacuum of fresh TOAST data
Date
Msg-id 13267.1197563721@sss.pgh.pa.us
Whole thread Raw
In response to Re: Heavy write activity on first vacuum of fresh TOAST data  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Heavy write activity on first vacuum of fresh TOAST data  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-performance
Tree view 
"Kevin Grittner" <Kevin.Grittner@wicourts.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

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Heavy write activity on first vacuum of fresh TOAST data
Next
From: "Kevin Grittner"
Date:
Subject: Re: Heavy write activity on first vacuum of fresh TOAST data