Re: How does the transaction buffer work? - Mailing list pgsql-performance

From Rod Taylor
Subject Re: How does the transaction buffer work?
Date
Msg-id 1118984715.78366.240.camel@home
Whole thread Raw
In response to Re: How does the transaction buffer work?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
> Now of course this isn't Nirvana, you must pay somewhere ;-) and our
> weak spot is the need for VACUUM.  But you have no need to fear large
> individual transactions.

No need to fear long running transactions other than their ability to
stop VACUUM from doing what it's supposed to be doing, thus possibly
impacting performance.
--


pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Needed: Simplified guide to optimal memory
Next
From: "Merlin Moncure"
Date:
Subject: Re: could not send data to client: