Re: Postgresql the right tool (queue using advisory_locks + long transactions)

From: Hannes Erven <hannes(at)erven(dot)at>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgresql the right tool (queue using advisory_locks + long transactions)
Date: 2014-04-27 21:07:00
Message-ID: 535D7174.1040006@erven.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

On 2014-04-27 21:53, Tom Lane wrote:
>
> Sitting on an open transaction for hours would be a bad idea.

I'm wondering why this is and what the consequences might be - I
thought, the MVCC model would handle that rather well?

Could please someone elaborate on this or provide some pointer? Thanks!

Best regards,

-hannes

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dorian Hoxha 2014-04-27 21:11:28 Re: Re: Postgresql the right tool (queue using advisory_locks + long transactions)
Previous Message David G Johnston 2014-04-27 20:07:05 Re: Postgresql the right tool (queue using advisory_locks + long transactions)