Re: New to PostgreSQL, performance considerations

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Daniel van Ham Colchete" <daniel(dot)colchete(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: New to PostgreSQL, performance considerations
Date: 2006-12-12 17:32:31
Message-ID: 5202.1165944751@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Daniel van Ham Colchete" <daniel(dot)colchete(at)gmail(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Ron 2006-12-12 17:56:28 Re: New to PostgreSQL, performance considerations
Previous Message Tom Lane 2006-12-12 17:13:59 Re: New to PostgreSQL, performance considerations