Обсуждение: rbtree test data
Hi there, I made available test data I used on http://www.sai.msu.su/~megera/wiki/2009-07-27, so anyone can reproduce my results. You can download data http://www.sai.msu.su/~megera/postgres/files/links2.sql.gz, it's big (580Mb) 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
On Sat, Jan 30, 2010 at 1:12 AM, Oleg Bartunov <oleg@sai.msu.su> wrote: > I made available test data I used on > http://www.sai.msu.su/~megera/wiki/2009-07-27, > so anyone can reproduce my results. You can download data > http://www.sai.msu.su/~megera/postgres/files/links2.sql.gz, it's big (580Mb) Ugh. My system has been sitting here for four hours trying to create the first GIN index. I think I'm going to have to give up. ...Robert
Robert Haas <robertmhaas@gmail.com> writes: > On Sat, Jan 30, 2010 at 1:12 AM, Oleg Bartunov <oleg@sai.msu.su> wrote: >> I made available test data I used on >> http://www.sai.msu.su/~megera/wiki/2009-07-27, >> so anyone can reproduce my results. You can download data >> http://www.sai.msu.su/~megera/postgres/files/links2.sql.gz, it's big (580Mb) > Ugh. My system has been sitting here for four hours trying to create > the first GIN index. I think I'm going to have to give up. Did you crank up maintenance_work_mem beforehand? regards, tom lane
On Tue, 2 Feb 2010, Robert Haas wrote: > On Sat, Jan 30, 2010 at 1:12 AM, Oleg Bartunov <oleg@sai.msu.su> wrote: >> I made available test data I used on >> http://www.sai.msu.su/~megera/wiki/2009-07-27, >> so anyone can reproduce my results. You can download data >> http://www.sai.msu.su/~megera/postgres/files/links2.sql.gz, it's big (580Mb) > > Ugh. My system has been sitting here for four hours trying to create > the first GIN index. I think I'm going to have to give up. My settings (only relevant) on my desktop ( 8Gb RAM, Intel(R) Core(TM)2 Duo CPU E6750 @ 2.66GHz : shared_buffers = 512MB #32MB # min 128kB work_mem = 32MB #1MB # min 64kB maintenance_work_mem = 256MB #16MB # min 1MB effective_cache_size = 1GB #128MB 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
On Wed, Feb 3, 2010 at 7:00 AM, Oleg Bartunov <oleg@sai.msu.su> wrote: > On Tue, 2 Feb 2010, Robert Haas wrote: > >> On Sat, Jan 30, 2010 at 1:12 AM, Oleg Bartunov <oleg@sai.msu.su> wrote: >>> >>> I made available test data I used on >>> http://www.sai.msu.su/~megera/wiki/2009-07-27, >>> so anyone can reproduce my results. You can download data >>> http://www.sai.msu.su/~megera/postgres/files/links2.sql.gz, it's big >>> (580Mb) >> >> Ugh. My system has been sitting here for four hours trying to create >> the first GIN index. I think I'm going to have to give up. > > My settings (only relevant) on my desktop ( 8Gb RAM, Intel(R) Core(TM)2 Duo > CPU E6750 @ 2.66GHz > : > > shared_buffers = 512MB #32MB # min 128kB > work_mem = 32MB #1MB # min 64kB > maintenance_work_mem = 256MB #16MB # min 1MB > effective_cache_size = 1GB #128MB OK, that helped. Although it was still long. :-) ...Robert