Re: Simple question on SELECT - Mailing list pgsql-general

From John R Pierce
Subject Re: Simple question on SELECT
Date
Msg-id 4EB86D96.4080200@hogranch.com
Whole thread Raw
In response to Re: Simple question on SELECT  (Edson Richter <richter@simkorp.com.br>)
List pgsql-general
On 11/07/11 3:30 PM, Edson Richter wrote:
> Thanks for the fast answer. Is there any way to avoid that? I mean, in
> MS SQL Server, I do have "with no_lock" (that produces dirty reads)?
> Or the way to go is the transaction isolation level?

there's no actual overhead in a single statement read transaction like
this.   Postgres uses a novel approach to MVCC.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast


pgsql-general by date:

Previous
From: Richard Broersma
Date:
Subject: Re: Simple question on SELECT
Next
From: Scott Marlowe
Date:
Subject: Re: Www emulator