Mike,
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.
And I'm testing with my fsync turned off.
Maybe if you lower your -t rate you are going to see this improvement.
Best regards,
Daniel
On 12/12/06, Michael Stone <[EMAIL PROTECTED]> wrote:
On Tue, Dec 12, 2006 at 07:10:34AM -0200, Daniel van Ham Colchete wrote:
>are you using "-mtune/-mcpu" or "-march" with GCC?
I used exactly the options you said you used.
>Witch GCC version? Are you working with a 32bits OS or 64bits?
3.3.5; 32
Mike Stone
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
