Re: Benchmark for GiST index?

On Thu, 20 Dec 2007, Koichi Suzuki wrote:

> I'm trying to run some GiST activities and see XLOG record structure.

Koichi, I tested update speed of GiST and GIN 
http://www.sai.msu.su/~megera/wiki/GinTestUpdate
It should generate a lot  XLOG traffic.

>
> README tells it runs PG8.2 or later.   Does it run with PG8.3beta4?
> It seems to depend upon tsearch2 in contrib.
>
> 2007/12/20, Teodor Sigaev <teodor@sigaev.ru>:
>> What kind of benchmark? I have benchmark for text search
>> http://www.sigaev.ru/cvsweb/cvsweb.cgi/ftsbench/
>> and several others, based on it.
>>
>>
>> Koichi Suzuki wrote:
>>> Hi,
>>>
>>> Does anybody have an information about GiST index benchmark?  I'm
>>> planning to run GiST benchmark and analyze WAL structure to see PG's
>>> dynamic behavior.
>>>
>>> Regards;
>>>
>>> ------
>>> Koichi Suzuki
>>>
>>> ---------------------------(end of broadcast)---------------------------
>>> TIP 3: Have you checked our extensive FAQ?
>>>
>>>                http://www.postgresql.org/docs/faq
>>
>> --
>> Teodor Sigaev                                   E-mail: teodor@sigaev.ru
>>                                                     WWW: http://www.sigaev.ru/
>>
>
>
>
    Regards,        Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83