Skip site navigation (1) Skip section navigation (2)

Re: COMMIT NOWAIT Performance Option

From: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
To: "J(dot) Andrew Rogers" <jrogers(at)neopolitan(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: COMMIT NOWAIT Performance Option
Date: 2007-03-01 03:34:21
Message-ID: 36e682920702281934v7ba7041dl6c16ca6ae19a4224@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On 2/28/07, Jonah H. Harris <jonah(dot)harris(at)gmail(dot)com> wrote:
> Last time I checked, Teradata used a modified Fletcher checksum as
> well; I wasn't aware of Adler32.

I added adler32 to Gurjeet Singh's crc testing utility, compiled it
with gcc 4.0.0 on a single-core Opteron running FC4, and configured it
for 8K block sizes.

GCC options were -mtune=opteron and the optimizations stated below:

Generic optimization:
test parameters:: SF=1, block_size=8, list_size=1000
Generating data... done. Time taken : 93 milliseconds
Generating CRC using PG (vanilla) algo... done. Time taken : 117 milliseconds
Verifying CRC using PG (vanilla) algo... done. Time taken : 89 milliseconds
Generating CRC using SliceBy8 algo... done. Time taken : 44 milliseconds
Verifying CRC using SliceBy8 algo... done. Time taken : 44 milliseconds
Generating CRC using Adler32 algo... done. Time taken : 52 milliseconds
Verifying CRC using Adler32 algo... done. Time taken : 53 milliseconds

Using -O2
test parameters:: SF=1, block_size=8, list_size=1000
Generating data... done. Time taken : 85 milliseconds
Generating CRC using PG (vanilla) algo... done. Time taken : 31 milliseconds
Verifying CRC using PG (vanilla) algo... done. Time taken : 30 milliseconds
Generating CRC using SliceBy8 algo... done. Time taken : 30 milliseconds
Verifying CRC using SliceBy8 algo... done. Time taken : 30 milliseconds
Generating CRC using Adler32 algo... done. Time taken : 14 milliseconds
Verifying CRC using Adler32 algo... done. Time taken : 14 milliseconds

Using -O3
test parameters:: SF=1, block_size=8, list_size=1000
Generating data... done. Time taken : 87 milliseconds
Generating CRC using PG (vanilla) algo... done. Time taken : 31 milliseconds
Verifying CRC using PG (vanilla) algo... done. Time taken : 31 milliseconds
Generating CRC using SliceBy8 algo... done. Time taken : 30 milliseconds
Verifying CRC using SliceBy8 algo... done. Time taken : 30 milliseconds
Generating CRC using Adler32 algo... done. Time taken : 14 milliseconds
Verifying CRC using Adler32 algo... done. Time taken : 15 milliseconds

Interesting...

-- 
Jonah H. Harris, Software Architect | phone: 732.331.1324
EnterpriseDB Corporation            | fax: 732.331.1301
33 Wood Ave S, 3rd Floor            | jharris(at)enterprisedb(dot)com
Iselin, New Jersey 08830            | http://www.enterprisedb.com/

In response to

Responses

pgsql-hackers by date

Next:From: Robert TreatDate: 2007-03-01 03:39:33
Subject: Re: SOC & user quotas
Previous:From: MageshwaranDate: 2007-03-01 03:31:21
Subject: POSTGRES WAL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group