Re: Regarding ambulkdelete, amvacuumcleanup index methods

2018-01-29 Thread Masahiko Sawada
On Thu, Jan 25, 2018 at 5:53 PM, Abinaya k wrote: > Thanks for your response. > > Hope those stats will be used by Query Planner. > > So, just for my understanding, if i don't return stats (returning NULL from > index_bulk_delete and index_vacuum_cleanup functions), Query Planner will > not consid

Re: Regarding ambulkdelete, amvacuumcleanup index methods

2018-01-25 Thread Abinaya k
Thanks for your response. Hope those stats will be used by Query Planner. So, just for my understanding, if i don't return stats (returning NULL from index_bulk_delete and index_vacuum_cleanup functions), Query Planner will not consider my Index as part of Query Path, beyond that i don't expect a

Re: Regarding ambulkdelete, amvacuumcleanup index methods

2018-01-23 Thread Masahiko Sawada
On Wed, Jan 24, 2018 at 1:27 PM, Abinaya k wrote: > Hai all, > We are building In-memory index extension for postgres. We would > capture table inserts, updates, deletes using triggers. During vacuum > operation, postgres would give calls to ambulkdelete, amvacuumcleanup (as > part of index

Regarding ambulkdelete, amvacuumcleanup index methods

2018-01-23 Thread Abinaya k
Hai all, We are building In-memory index extension for postgres. We would capture table inserts, updates, deletes using triggers. During vacuum operation, postgres would give calls to ambulkdelete, amvacuumcleanup (as part of index cleanup). As we handle all updates, deletes using triggers, w

Fwd: Regarding ambulkdelete, amvacuumcleanup index methods

2018-01-23 Thread Abinaya k
-- Forwarded message -- From: "Abinaya k" Date: Jan 23, 2018 1:43 PM Subject: Regarding ambulkdelete, amvacuumcleanup index methods To: Cc: Hai all, We are building In-memory index extension for postgres. We would capture table inserts, updates, deletes usin

Regarding ambulkdelete, amvacuumcleanup index methods

2018-01-23 Thread Abinaya k
Hai all, We are building In-memory index extension for postgres. We would capture table inserts, updates, deletes using triggers. During vacuum operation, postgres would give calls to ambulkdelete, amvacuumcleanup (as part of index cleanup). As we handle all updates, deletes using triggers, w