How about having a constant sized "fastupdate" buffer, of say 100 rows or a fixed number of pages, and when that becomes full, the next inserter will have to pay the price of updating the index and flushing

I'm not sure that is acceptable because flushing pending list may take several seconds in unpredictable moment.

the buffer. To keep that overhead out of the main codepath, we could make autovacuum to flush the buffers periodically.

Do you mean that GIN sends a "smoke signal" to the autovacuum launcher process to ask about vacuum?

Teodor Sigaev                                   E-mail: [EMAIL PROTECTED]

Sent via pgsql-patches mailing list (
To make changes to your subscription:

Reply via email to