Re: [PATCHES] GIN improvements

2) fast insert into GIN New version: http://www.sigaev.ru/misc/fast_insert_gin-0.6.gz Changes: - added option FASTUPDATE=(1|t|true|on|enable|0|f|false|disable) for CREATE/ALTER command for GIN indexes - Since there wasn't any comments on first email, pg_am.aminsertcleanup optional method

Re: [PATCHES] GIN improvements

Teodor Sigaev wrote: 2) fast insert into GIN New version: http://www.sigaev.ru/misc/fast_insert_gin-0.6.gz Changes: - added option FASTUPDATE=(1|t|true|on|enable|0|f|false|disable) for CREATE/ALTER command for GIN indexes I think we should try to make it automatic. I'm not sure how. How

Re: [PATCHES] GIN improvements

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

[PATCHES] Patch for dependency traversal during DROP

The attached patch rewrites DROP recursion according to my sketch here: http://archives.postgresql.org/pgsql-hackers/2008-05/msg00301.php It gets rid of a lot of unwanted NOTICE messages during drop, specifically by ensuring that AUTO/INTERNAL drops are silent even when they cascade from other