Re: Pluggable Indexes

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
Cc: Gregory Stark <stark(at)enterprisedb(dot)com>, Simon Riggs <simon(at)2ndQuadrant(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Pluggable Indexes
Date: 2009-01-21 19:45:50
Message-ID: 49777B6E.9030002@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Ron Mayer wrote:
> Early (2005)
> GIST indexes were very painful in production environments because vacuuming
> them held locks for a *long* time (IIRC, an hour or so on my database) on
> the indexes locking out queries. Was that just a shortcoming of the
> implementation, or was it a side-effect of them not supporting recoverability.

The former.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2009-01-21 20:10:10 Re: FWD: Re: Updated backslash consistency patch
Previous Message Martin Pihlak 2009-01-21 19:45:08 Re: reducing statistics write overhead