From: | momjian(at)svr1(dot)postgresql(dot)org (Bruce Momjian) |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Update count(*) discussion ideas: < BY col {DESC} LIMIT 1. |
Date: | 2005-01-22 20:05:24 |
Message-ID: | 20050122200524.A4F473A4F9F@svr1.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Log Message:
-----------
Update count(*) discussion ideas:
< BY col {DESC} LIMIT 1. Completing this item involves making this
> BY col {DESC} LIMIT 1. Completing this item involves doing this
< invalidated if anyone modifies the table.
<
> invalidated if anyone modifies the table. Another idea is to
> get a count directly from a unique index, but for this to be
> faster than a sequential scan it must avoid access to the heap
> to obtain tuple visibility information.
>
> * Allow data to be pulled directly from indexes
>
> Currently indexes do not have enough tuple tuple visibility
> information to allow data to be pulled from the index without
> also accessing the heap. One way to allow this is to set a bit
> to index tuples to indicate if a tuple is currently visible to
> all transactions when the first valid heap lookup happens. This
> bit would have to be cleared when a heap tuple is expired.
>
Modified Files:
--------------
pgsql/doc:
TODO (r1.1434 -> r1.1435)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1434&r2=1.1435)
From | Date | Subject | |
---|---|---|---|
Next Message | User Dpage | 2005-01-22 20:11:13 | pginstaller - web: New Directory |
Previous Message | Neil Conway | 2005-01-22 05:14:28 | pgsql: This patch updates the regression tests to allow "make |