Re: Synchronized scans

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Synchronized scans
Date: 2007-06-08 17:24:22
Message-ID: 1181323462.7660.183.camel@dogma.v10.wvs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

On Fri, 2007-06-08 at 11:05 +0100, Heikki Linnakangas wrote:
> BTW: Should we do the synchronization in the non-page-at-a-time mode?
> It's not many lines of code to do so, but IIRC that codepath is only
> used for catalog access. System tables really shouldn't grow that big,
> and if they do we shouldn't be doing seq scans for them anyway. Does the
> unstable ordering confuse any catalog accesses?

http://archives.postgresql.org/pgsql-hackers/2006-09/msg01199.php

There is a very minor assumption there that scans on pg_class will
return in the same order. I'm not sure if that's even a problem.

Regards,
Jeff Davis

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2007-06-08 17:43:51 Re: Synchronized scans
Previous Message Tom Lane 2007-06-08 16:22:02 Re: Synchronized scans