Re: not aborting transactions on failed select - Mailing list pgsql-general

From David Johnston
Subject Re: not aborting transactions on failed select
Date
Msg-id 1378913016745-5770478.post@n5.nabble.com
Whole thread Raw
In response to Re: not aborting transactions on failed select  (Sergey Shelukhin <sergey@hortonworks.com>)
List pgsql-general
Sergey Shelukhin wrote
> Due to presence of a large number of historical installations {doing such
> and such} is not viable.

Yeah, PostgreSQL faces this same issue....

If you intend to stay here long, and we hope you do (welcome by the way), it
is customary to bottom-post on these lists.

One other thought is that exception generation and handling is expensive.
It probably is a fair trade-off - since the ORM is already slow the added
overhead of the failing optimization query shouldn't be that noticeable.
Failure means either bad code or incorrect pre-conditions; both of which
should be explicitly checked and reported on.  If those checks fail the
system can auto-configure to use the backup (ORM) channel instead of the
primary (optimized) channel.

David J.




--
View this message in context:
http://postgresql.1045698.n5.nabble.com/not-aborting-transactions-on-failed-select-tp5770387p5770478.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Sergey Shelukhin
Date:
Subject: Re: not aborting transactions on failed select
Next
From: Steve Crawford
Date:
Subject: Re: invalid frontend message type 136