Reading all tuples in Index Access Method

From: Sushrut Shivaswamy <sushrut(dot)shivaswamy(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Reading all tuples in Index Access Method
Date: 2024-08-28 14:21:22
Message-ID: CAH5mb98yWxQSWF6=aOYtOSCuKGHQ1auoC4xPPPYwj2tKOjORJQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I'm trying to create an Index Access Method Roting.
Building the index requires iterating over all rows and calculating,
which is then used during index construction.

The methods in the IndexAmRoutine seem to deal with insertion / index build
one row at a time.
Is there any workaround you can suggest that would allow me to calculate
the median of a column,
store it someplace and then use it during Inserts to the index?

Thanks,
Sushrut

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrei Lepikhov 2024-08-28 14:26:22 Remove unnecessary check on set-returning functions in values_lists
Previous Message Peter Geoghegan 2024-08-28 13:54:12 Re: Showing primitive index scan count in EXPLAIN ANALYZE (for skip scan and SAOP scans)