Re: Postgres performance - Mailing list pgsql-sql

From Mauro Bertoli
Subject Re: Postgres performance
Date
Msg-id 20050302093344.49749.qmail@web51404.mail.yahoo.com
Whole thread Raw
In response to Re: Postgres performance  (Richard Huxton <dev@archonet.com>)
List pgsql-sql
Hi, thanks a lot! you are rigth, but I did read your
message ;) 
Yes,
1- I misconfigured PostgreSQL (I thought that was
already configured in base to the released version -
Fedora Core 3 64bit).
2- The bench is, clearly after your precisations, an
MySQL tuned application tests.
3- I think the bench test only one connection, I
didn't see (in a fast reading) no threading request in
the bench code to simulate users requests.
4- I didn't test transaction-safe (that isn't used
explicitly in my application)I understand it isn't simple.. I use the dbms in data
analysis environment and the more time is spent in
query (php is 0.1%) with more sub-selects and maybe
there's, in the same time, from 1 to 1000 users
insert/update data. I tests the dbms with my data
analysis framework simulating an super-extensive
request. 
Do you know where I can find an tutorial to configure
hardware dependent Postgres internal values?
Thx, best regards,Mauro

    
___________________________________ 
Nuovo Yahoo! Messenger: E' molto più divertente: Audibles, Avatar, Webcam, Giochi, Rubrica… Scaricalo ora! 
http://it.messenger.yahoo.it


pgsql-sql by date:

Previous
From: Mauro Bertoli
Date:
Subject: Re: Postgres performance
Next
From: Stephan Szabo
Date:
Subject: Re: Simple delete takes hours