Re: Simple question on SELECT

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Simple question on SELECT
Date: 2011-11-07 23:45:26
Message-ID: 4EB86D96.4080200@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2011-11-07 23:56:55 Re: Www emulator
Previous Message Richard Broersma 2011-11-07 23:40:55 Re: Simple question on SELECT