Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT FOR SHARE - Mailing list pgsql-general

From Tom Lane
Subject Re: SELECT FOR SHARE
Date
Msg-id 3167.1128691777@sss.pgh.pa.us
Whole thread Raw
In response to SELECT FOR SHARE  ("Ilja Golshtein" <ilejn@yandex.ru>)
Responses Re: SELECT FOR SHARE  ("Ilja Golshtein" <ilejn@yandex.ru>)
List pgsql-general
Tree view 
"Ilja Golshtein" <ilejn@yandex.ru> writes:
> I'm interested in SELECT ... FOR SHARE 8.1 feature. I'd tried to
> measure performance degradation and got something about 30-60% for
> queries retrieve a lot of rows.

Degradation relative to what?

            regards, tom lane

pgsql-general by date:

Previous
From: han.holl@informationslogik.nl
Date:
Subject: How to inject knowledge into a Postgres database
Next
From: "Andrus"
Date:
Subject: Re: PostgreSQL 8.1 vs. MySQL 5.0?