Re: clustering without locking

From: Scott Ribe <scott_ribe(at)killerbytes(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: clustering without locking
Date: 2008-05-02 15:08:41
Message-ID: C4408A99.968B8%scott_ribe@killerbytes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Huh? A plain vacuum wouldn't fix that; a vacuum full would close up the
> hole, but (a) it'd not preserve the row ordering, and (b) it'd take an
> exclusive lock.

OK.

--
Scott Ribe
scott_ribe(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 722-0567 voice

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Javier Olazaguirre 2008-05-02 15:13:59 Speed up repetitive queries
Previous Message Andrew Sullivan 2008-05-02 14:55:41 Re: Swap Space and vm.oom_kill_allocating_task