Re: New to PostgreSQL, performance considerations - Mailing list pgsql-performance

From Tom Lane
Subject Re: New to PostgreSQL, performance considerations
Date
Msg-id 5202.1165944751@sss.pgh.pa.us
Whole thread Raw
In response to Re: New to PostgreSQL, performance considerations  ("Daniel van Ham Colchete" <daniel.colchete@gmail.com>)
List pgsql-performance
"Daniel van Ham Colchete" <daniel.colchete@gmail.com> writes:
> I'm making some other tests here at another hardware (also Gentoo). I
> found out that PostgreSQL stops for a while if I change the -t
> parameter on bgbench from 600 to 1000 and I have ~150 tps instead of
> ~950tps.

> I don't know why PostgreSQL stoped, but it was longer than 5 seconds
> and my disk IO was comsuming 100% of my CPU time during this period.

Checkpoint?

            regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: New to PostgreSQL, performance considerations
Next
From: Ron
Date:
Subject: Re: New to PostgreSQL, performance considerations