Jeff Davis wrote:
On Thu, 2007-05-31 at 09:08 +0100, Heikki Linnakangas wrote:
* moved the sync scan stuff to a new file access/heapam/syncscan.c.
heapam.c is long enough already, and in theory the same mechanism could
be used for large bitmap heap scans in the future.
Good idea, I hadn't
I'm now done with this patch and testing it.
I fixed a little off-by-one in backward scan, not inited branch, but I
was unable to test it. It seems that code is actually never used because
that case is optimized to a rewind in the executor. I marked those
seemingly unreachable places in the
Heikki Linnakangas [EMAIL PROTECTED] writes:
For the record, this patch has a small negative impact on scans like
SELECT * FROM foo LIMIT 1000. If such a scan is run repeatedly, in CVS
HEAD the first 1000 rows will stay in buffer cache, but with the patch
each scan will start from roughly
Tom Lane wrote:
Heikki Linnakangas [EMAIL PROTECTED] writes:
For the record, this patch has a small negative impact on scans like
SELECT * FROM foo LIMIT 1000. If such a scan is run repeatedly, in CVS
HEAD the first 1000 rows will stay in buffer cache, but with the patch
each scan will start
Heikki Linnakangas wrote:
Tom Lane wrote:
Heikki Linnakangas [EMAIL PROTECTED] writes:
For the record, this patch has a small negative impact on scans like
SELECT * FROM foo LIMIT 1000. If such a scan is run repeatedly, in CVS
HEAD the first 1000 rows will stay in buffer cache, but with
Bruce Momjian [EMAIL PROTECTED] writes:
As I understand it, the problem is that while currently LIMIT without
ORDER BY always starts at the beginning of the table, it will not with
this patch. I consider that acceptable.
It's definitely going to require stronger warnings than we have now
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
As I understand it, the problem is that while currently LIMIT without
ORDER BY always starts at the beginning of the table, it will not with
this patch. I consider that acceptable.
It's definitely going to require stronger warnings than
On Mon, 2007-06-04 at 10:53 +0100, Heikki Linnakangas wrote:
I'm now done with this patch and testing it.
Great!
For the record, this patch has a small negative impact on scans like
SELECT * FROM foo LIMIT 1000. If such a scan is run repeatedly, in CVS
HEAD the first 1000 rows will stay
Tom Lane wrote:
Heikki Linnakangas [EMAIL PROTECTED] writes:
For the record, this patch has a small negative impact on scans like
SELECT * FROM foo LIMIT 1000. If such a scan is run repeatedly, in CVS
HEAD the first 1000 rows will stay in buffer cache, but with the patch
each scan will
Alvaro Herrera wrote:
Tom Lane wrote:
Heikki Linnakangas [EMAIL PROTECTED] writes:
For the record, this patch has a small negative impact on scans like
SELECT * FROM foo LIMIT 1000. If such a scan is run repeatedly, in CVS
HEAD the first 1000 rows will stay in buffer cache, but with the patch
Jeff Davis wrote:
No surprise here, as you and Bruce have already pointed out.
If we wanted to reduce the occurrence of this phenomena, we could
perhaps time out the hints so that it's impossible to pick up a hint
from a scan that finished 5 minutes ago.
It doesn't seem helpful to further
Heikki Linnakangas [EMAIL PROTECTED] writes:
I don't think anyone can reasonably expect to get the same ordering when
the same query issued twice in general, but within the same transaction
it wouldn't be that unreasonable. If we care about that, we could keep
track of starting locations
Tom Lane wrote:
Heikki Linnakangas [EMAIL PROTECTED] writes:
I don't think anyone can reasonably expect to get the same ordering when
the same query issued twice in general, but within the same transaction
it wouldn't be that unreasonable. If we care about that, we could keep
track of
On Jun 4, 2007, at 15:24 , Heikki Linnakangas wrote:
I don't think anyone can reasonably expect to get the same ordering
when the same query issued twice in general, but within the same
transaction it wouldn't be that unreasonable.
The order rows are returned without an ORDER BY clause
On Mon, 2007-06-04 at 16:42 -0400, Tom Lane wrote:
Heikki Linnakangas [EMAIL PROTECTED] writes:
I don't think anyone can reasonably expect to get the same ordering when
the same query issued twice in general, but within the same transaction
it wouldn't be that unreasonable. If we care
On Mon, 2007-06-04 at 22:09 +0100, Heikki Linnakangas wrote:
I think the real problem here is that the first scan is leaving state
behind that changes the behavior of the next scan. Which can have no
positive benefit, since obviously the first scan is not still
proceeding; the best you
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?
Jeff Davis wrote:
On Mon, 2007-06-04 at 22:09 +0100, Heikki Linnakangas wrote:
I think the real problem here is that the first scan is leaving state
behind that changes the behavior of the next scan. Which can have no
positive benefit, since obviously the first scan is not still
proceeding;
Jeff Davis [EMAIL PROTECTED] writes:
My thought was that every time the location was reported by a backend,
it would store 3 pieces of information, not 2:
* relfilenode
* the PID of the backend that created or updated this particular hint
last
* the location
Then, on heap_endscan() (if
Heikki Linnakangas [EMAIL PROTECTED] writes:
Were you thinking of storing the PID of the backend that originally created
the
hint, or updating the PID every time the hint is updated? In any case, we
still
wouldn't know if there's other scanners still running.
My reaction was if you
On Mon, 2007-06-04 at 18:25 -0400, Tom Lane wrote:
But note that barring backend crash, once all the scans are done it is
guaranteed that the hint will be removed --- somebody will be last to
update the hint, and therefore will remove it when they do heap_endscan,
even if others are not quite
Jeff Davis [EMAIL PROTECTED] writes:
The problem is, I think people would be more frustrated by 1 in 1000
queries starting the scan in the wrong place because a hint was deleted,
Yeah --- various people have been complaining recently about how we have
good average performance and bad worst
22 matches
Mail list logo