Re: old synchronized scan patch - Mailing list pgsql-hackers

From Zeugswetter Andreas ADI SD
Subject Re: old synchronized scan patch
Date
Msg-id E1539E0ED7043848906A8FF995BDA579018FEBAB@m0143.s-mxs.net
Whole thread Raw
In response to Re: old synchronized scan patch  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: old synchronized scan patch
List pgsql-hackers
> To open up the implementation topic:
>
> My current patch starts a new sequential scan on a given relation at
the
> page of an already-running scan.

I think it should start earlier to make use of the already cached part
of the table.
It is hard to determine, or guess how much is still in cache though.
As a start you could maybe use some (small to be safe) fraction of
effective_cache_size
or shared_buffers.

Andreas


pgsql-hackers by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Postgres95 archives in mbox format
Next
From: "Heikki Linnakangas"
Date:
Subject: Re: old synchronized scan patch