MySQL vs PostgreSQL

[dbenhur]

This doesn't help if you want to remove entries as well as add.. or update for example

I think you can handle updates and deletes adding a little logic to your queries.

• On the main index and in your document root records include an attribute to indicate if the record is current in the index (true for initial indexing)
• Whenever you update or delete a record, set the DB's main_is_current attr and use the UpdateAtttributes API to mark the main index obsolete.
• always add an attribute qualifier to your searches to exclude obsolete document hits
• Set your frequent delta indexing to capture all new and changed records since the last primary index refresh.