From: | "Merlin Moncure" <mmoncure(at)gmail(dot)com> |
---|---|
To: | "ITAGAKI Takahiro" <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> |
Cc: | "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: HOT pgbench results |
Date: | 2007-08-15 01:25:48 |
Message-ID: | b42b73150708141825o7405e423hb74d222be788aedb@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 8/14/07, ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> wrote:
> Heikki Linnakangas <heikki(at)enterprisedb(dot)com> wrote:
>
> > I ran some CPU intensive pgbench tests on HOT. Results are not
> > surprising, HOT makes practically no difference on the total transaction
> > rate, but reduces the need to vacuum:
> >
> > unpatched HOT
> > tps 3680 3790
> > WAL written(MB) 5386 4804
> > checkpoints 10 9
> > autovacuums 116 43
> > autoanalyzes 139 60
>
> I also ran pgbench with/without HOT using a bit different configurations
> (pgbench -s10 -c10 -t500000). There were 10% performance win on HOT,
> although the test was CPU intensive and with FILLFACTOR=100%.
I'm curious why I am seeing results so different from everybody else
(I had almost double tps with HOT). Are you running fsync on/off?
Any other changes to postgresql.conf?
merlin
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2007-08-15 01:48:34 | Re: [mmoncure@gmail.com: Re: [GENERAL] array_to_set functions] |
Previous Message | Andrew Dunstan | 2007-08-15 00:54:01 | Re: CVS corruption/mistagging? |