| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
| Cc: | Jeff Davis <pgsql(at)j-davis(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Another idea for index-only scans |
| Date: | 2007-08-16 23:19:01 |
| Message-ID: | 14220.1187306341@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
>> On Wed, 2007-08-15 at 11:54 -0400, Bruce Momjian wrote:
>>> A third idea would be for a heap scan to check if all rows are visible
>>> and if so set a per-table flag which can be checked by index scans.
> I think it's too coarse-grained to be really useful. If it was one bit
> per page it could work, but one bit per relation is going to be reset
> too frequently.
Another problem it would have is that the flag would be a single point
of contention.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc G. Fournier | 2007-08-16 23:59:57 | Re: [HACKERS] Re: cvsweb busted (was Re: pgsql: Repair problems occurring when multiple RI updates have to be) |
| Previous Message | Magnus Hagander | 2007-08-16 21:16:09 | Re: [HACKERS] Re: cvsweb busted (was Re: pgsql: Repair problems occurring when multiple RI updates have to be) |