Re: code question: storing INTO relation
От | Simon Riggs |
---|---|
Тема | Re: code question: storing INTO relation |
Дата | |
Msg-id | 1100430398.2950.129.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: code question: storing INTO relation (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: code question: storing INTO relation
|
Список | 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 по дате отправления: