Search Postgresql Archives

Bulkdelete and Vacuum operations on custom index

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi all,
I am currently implementing some index access methods on top of PostgreSQL. Until now, it is pretty fine and working properly. However, I am now doing the implementation of bulk deletion and vacuum of the structure. I don't know exactly, how to achieve this because it would be much easier to just collect statistics in bulkdelete and to implement the "real deal" of deleting the particular entries from my structures when vacuum is called on the index. Is it legitimate to do this: just collect statistics and pass the statistics and items to be deleted in main memory back to the caller and perform the real deletion of entries in vacuum? It would be much easier for me, if I would do this, because of the general structure I have here.
As far as I understand the documentation, vacuum is called when bulkdelete does return some statistics that some entries have been removed. If I would now put some additional information (namely the tuples) that have been deleted to the statistics and pass all of these data to vacuum (like in GiST whereas GiST only sets up a boolean flag) and then would delete the whole collected entries (stored somewhere in main memory), would this be still OK?
Actually I don't know exactly, if this could be done properly, but it would help me much because if I would use a standard approach of deleting in bulk delete and reorganizing in vacuum, I would get into some trouble probably and would have to rethink my whole algorithms (which I was testing in main memory in some outstanding project, before).
Thanks in advance.

Best regards
	Carsten Kropf
-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux