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@xxxxxxxxx> 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
