Skip site navigation (1) Skip section navigation (2)

Re: [COMMITTERS] pgsql: Implement "fastupdate" support for GIN indexes, in which we try

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Tom Lane <tgl(at)postgresql(dot)org>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [COMMITTERS] pgsql: Implement "fastupdate" support for GIN indexes, in which we try
Date: 2009-03-24 20:52:22
Message-ID: 603c8f070903241352q743e3180s38478013bc0dc7c6@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackers
2009/3/24 Tom Lane <tgl(at)postgresql(dot)org>:
> Implement "fastupdate" support for GIN indexes, in which we try to accumulate
> multiple index entries in a holding area before adding them to the main index
> structure.  This helps because bulk insert is (usually) significantly faster
> than retail insert for GIN.
>
> This patch also removes GIN support for amgettuple-style index scans.  The
> API defined for amgettuple is difficult to support with fastupdate, and
> the previously committed partial-match feature didn't really work with
> it either.  We might eventually figure a way to put back amgettuple
> support, but it won't happen for 8.4.
>
> catversion bumped because of change in GIN's pg_am entry, and because
> the format of GIN indexes changed on-disk (there's a metapage now,
> and possibly a pending list).

Will this break pg_migrator?

...Robert

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2009-03-24 21:16:04
Subject: Re: Re: [COMMITTERS] pgsql: Implement "fastupdate" support for GIN indexes, in which we try
Previous:From: Tom LaneDate: 2009-03-24 20:18:42
Subject: Re: GIN fast insert

pgsql-committers by date

Next:From: Tom LaneDate: 2009-03-24 21:12:56
Subject: pgsql: Fix stupid parenthesization mistake.
Previous:From: Tom LaneDate: 2009-03-24 20:17:18
Subject: pgsql: Implement "fastupdate" support for GIN indexes, in which we try

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group