On Wed, Feb 3, 2010 at 7:00 AM, Oleg Bartunov <o...@sai.msu.su> wrote: > On Tue, 2 Feb 2010, Robert Haas wrote: > >> On Sat, Jan 30, 2010 at 1:12 AM, Oleg Bartunov <o...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers