Sync scan & regression tests - Mailing list pgsql-hackers

From Konstantin Knizhnik
Subject Sync scan & regression tests
Date
Msg-id 6e6b91a6-afc5-d446-7e4a-2716860dd10e@garret.ru
Whole thread Raw
Responses Re: Sync scan & regression tests
Re: Sync scan & regression tests
List pgsql-hackers
Hi hackers,

Is it is ok, that regression tests do not pass with small value of 
shared buffers (for example 1Mb)?

Two tests are failed because of sync scan - this tests cluster.sql and 
portals.sql perform seqscan without explicit order by and expect that 
data will be returned in particular order. But because of sync scan it 
doesn't happen. Small shared buffers are needed to satisfy seqscan 
criteria in heapam.c: `scan->rs_nblocks > NBuffers / 4` for tenk1 table.

More general question - is it really good that in situation when there 
is actually no concurrent queries, seqscan is started not from the first 
page?





pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Use of additional index columns in rows filtering
Next
From: Ahmed Ibrahim
Date:
Subject: Re: There should be a way to use the force flag when restoring databases