Re: [HACKERS] gin fast insert performance

2009-01-27 Thread Teodor Sigaev
Here is a test of the fast insert patch. The patch has gone through some changes, so this set of tests is to see the current performance impact compared with HEAD. The test is simple: inserting a bunch of integer arrays into a table with a GIN index on the array column. I'm testing with small

Re: [HACKERS] gin fast insert performance

2009-01-27 Thread Teodor Sigaev
Sorry, lost test sript BTW, is btree_gin ready to commit by your opinion? -- Teodor Sigaev E-mail: teo...@sigaev.ru WWW: http://www.sigaev.ru/ CREATE OR REPLACE FUNCTION gena() RETURNS _int4 AS $$ SELECT

Re: [HACKERS] gin fast insert performance

2009-01-27 Thread Jeff Davis
On Tue, 2009-01-27 at 20:36 +0300, Teodor Sigaev wrote: You didn't provide distributions of array's element, number of unique element and so on. And I make simple test script, which generates data rather close to typical tsearch installation (see tst.sql). The arrays I was inserting were

[HACKERS] gin fast insert performance

2009-01-26 Thread Jeff Davis
Here is a test of the fast insert patch. The patch has gone through some changes, so this set of tests is to see the current performance impact compared with HEAD. The test is simple: inserting a bunch of integer arrays into a table with a GIN index on the array column. I'm testing with small