Re: code question: storing INTO relation - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: code question: storing INTO relation
Date
Msg-id 1100430398.2950.129.camel@localhost.localdomain
Whole thread Raw
In response to Re: code question: storing INTO relation  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: code question: storing INTO relation
List pgsql-hackers
On Fri, 2004-11-12 at 23:13, Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Greg Stark wrote:
> >> I think that's already done for CREATE INDEX/REINDEX.
> 
> > I don't think so.  Can someone confirm?
> 
> Greg is correct --- at least for btree build, which is the only index
> type we have WAL-ified at all :-(

[well...at least they're optimized then...  :) ]

With regard to the other index types, my opinion was:
HASH - works OK, but a pain to administer, no huge benefit in using
R-TREE - slightly broken in places, limited in usablity
GiST - index of choice for PostGIS, TSearch2, in need of optimization

Following recent optimization work on GiST, it now seems worth the
trouble to add WAL logging to it. ISTM that the other two aren't widely
used enough to make it worthwhile to spend time on, evidence for which
is also that no one ever has, up 'til now.

Time-management seems to be the key to making progress in the most
important areas...

-- 
Best Regards, Simon Riggs



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Increasing the length of
Next
From: Simon Riggs
Date:
Subject: Re: postmaster segfaults with HUGE table