Re: Benchmark for GiST index?

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Koichi Suzuki <koichi(dot)szk(at)gmail(dot)com>
Cc: Teodor Sigaev <teodor(at)sigaev(dot)ru>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Benchmark for GiST index?
Date: 2007-12-20 08:21:13
Message-ID: Pine.LNX.4.64.0712201119070.13244@sn.sai.msu.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)sigaev(dot)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(at)sigaev(dot)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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2007-12-20 08:32:38 Re: pgwin32_open returning EINVAL
Previous Message Koichi Suzuki 2007-12-20 07:55:30 Re: Benchmark for GiST index?