Обсуждение: Regarding drop index
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
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?
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
--
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