Re: Benchmark for GiST index?

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

Oleg;

Thanks for the information. I'll try your code.

2007/12/20, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>:
> 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
>

--
------
Koichi Suzuki

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-12-20 15:11:10 Re: pgwin32_open returning EINVAL
Previous Message Brian Hurt 2007-12-20 14:42:09 Re: Sorting Improvements for 8.4