| Lists: | pgsql-hackers |
|---|
| From: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
|---|---|
| To: | Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | rbtree test data |
| Date: | 2010-01-30 06:12:16 |
| Message-ID: | Pine.LNX.4.64.1001300909510.16860@sn.sai.msu.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
| Cc: | Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: rbtree test data |
| Date: | 2010-02-03 01:01:25 |
| Message-ID: | 603c8f071002021701m276ef209lf748510f830b757f@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
On Sat, Jan 30, 2010 at 1:12 AM, Oleg Bartunov <oleg(at)sai(dot)msu(dot)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
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: rbtree test data |
| Date: | 2010-02-03 02:00:47 |
| Message-ID: | 14262.1265162447@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> On Sat, Jan 30, 2010 at 1:12 AM, Oleg Bartunov <oleg(at)sai(dot)msu(dot)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
| From: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: rbtree test data |
| Date: | 2010-02-03 12:00:40 |
| Message-ID: | Pine.LNX.4.64.1002031459101.16860@sn.sai.msu.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
On Tue, 2 Feb 2010, Robert Haas wrote:
> On Sat, Jan 30, 2010 at 1:12 AM, Oleg Bartunov <oleg(at)sai(dot)msu(dot)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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
| Cc: | Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: rbtree test data |
| Date: | 2010-02-03 15:58:37 |
| Message-ID: | 603c8f071002030758x78498dd0xadd43af5042cddb5@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
On Wed, Feb 3, 2010 at 7:00 AM, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> wrote:
> On Tue, 2 Feb 2010, Robert Haas wrote:
>
>> On Sat, Jan 30, 2010 at 1:12 AM, Oleg Bartunov <oleg(at)sai(dot)msu(dot)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