Regarding drop index

Hi Abinaya,

Have you seen some benchmarks showing that an in-memory index will fix some
bottlenecks?

Do you have an idea how much of a gain this will provide?

Can you point to a github repo for it?

Cheers,
Ivan

On Tue, Jan 30, 2018 at 1:12 AM, Abinaya Kajendiran <abinayakajee@gmail.com>
wrote:

Hello all,

We are building in-memory index extension for postgres. For drop index
query, does postgres notify me through index access methods?

Currently, we are using event triggers to capture drop index. If there is
a better way, please do suggest.

Thanks in advance.

Regards,
Abinaya K

--
Ivan Novick, Product Manager Pivotal Greenplum
inovick@pivotal.io -- (Mobile) 408-230-6491
https://www.youtube.com/GreenplumDatabase

On 1/30/18 04:12, Abinaya Kajendiran wrote:

    We are building in-memory index extension for postgres. For drop
index query, does postgres notify me through index access methods?

No, the access methods just write into blocks for the file they are told
about. The deleting of that file is not handled by the access methods.

Currently, we are using event triggers to capture drop index. If there
is a better way, please do suggest.

An event trigger will probably do for now. But you are venturing into
uncharted territory, so you will have to find your own best solution.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services