From: | Teodor Sigaev <teodor(at)sigaev(dot)ru> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>, pgsql-general(at)postgresql(dot)org, Gianni Ciolli <gianni(dot)ciolli(at)2ndquadrant(dot)it> |
Subject: | Re: still gin index creation takes forever |
Date: | 2008-11-13 19:11:39 |
Message-ID: | 491C7BEB.7070008@sigaev.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> changing it; I've applied a patch for that. I'm still not quite
> convinced that Ivan isn't seeing some other issue though.
Thank you
> In the meantime, I noticed something odd while experimenting with your
> test case: when running with default maintenance_work_mem = 16MB,
> there is a slowdown of 3x or 4x for the un-ordered case, just as you
> say. But at maintenance_work_mem = 200MB I see very little difference.
> This doesn't make sense to me --- it seems like a larger workspace
> should result in more difference because of greater chance to dump a
> lot of tuples into the index at once. Do you know why that's happening?
I suppose, if maintenance_work_mem is rather big then all data of index
accumulates in memory and so it writes at disk at once. With that test's options
size of index is equal to 40Mb.
--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/
From | Date | Subject | |
---|---|---|---|
Next Message | Sam Mason | 2008-11-13 19:14:02 | Re: sort_mem param of postgresql.conf |
Previous Message | Scott Marlowe | 2008-11-13 19:10:45 | Re: Tweaking PG (again) |