Re: Synchronized scans - Mailing list pgsql-patches

From Michael Glaesemann
Subject Re: Synchronized scans
Date
Msg-id E09C298D-6D54-415F-9C39-FC7A6BFF72AE@seespotcode.net
Whole thread Raw
In response to Re: Synchronized scans  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-patches
On Jun 4, 2007, at 16:34 , Heikki Linnakangas wrote:

> LIMIT without ORDER BY is worse because it not only returns tuples
> in different order, but it can return different tuples altogether
> when you run it multiple times.

Wouldn't DISTINCT ON suffer from the same issue without ORDER BY?

Michael Glaesemann
grzm seespotcode net



pgsql-patches by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Synchronized scans
Next
From: Tom Lane
Date:
Subject: Re: Synchronized scans