Обсуждение: Benchmark for GiST index?
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
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/
I'm trying to run some GiST activities and see XLOG record structure. 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/ > -- ------ Koichi Suzuki
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
Oleg; Thanks for the information. I'll try your code. 2007/12/20, Oleg Bartunov <oleg@sai.msu.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@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 > -- ------ Koichi Suzuki