Re: New to PostgreSQL, performance considerations

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 <mstone+postgres(at)mathom(dot)us> 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
>