Re: How does the transaction buffer work?

From: Rod Taylor <pg(at)rbt(dot)ca>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org, Veikko Mäkinen <veikko(dot)makinen(at)ecom(dot)fi>
Subject: Re: How does the transaction buffer work?
Date: 2005-06-17 05:05:15
Message-ID: 1118984715.78366.240.camel@home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.
--

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2005-06-17 12:49:15 Re: could not send data to client:
Previous Message Alvaro Herrera 2005-06-17 04:46:43 Re: Needed: Simplified guide to optimal memory