[PERFORM] Which plattform do you recommend I run PostgreSQL for best performance?

2004-10-12 Thread nd02tsk
Hello I am doing a comparison between MySQL and PostgreSQL. In the MySQL manual it says that MySQL performs best with Linux 2.4 with ReiserFS on x86. Can anyone official, or in the know, give similar information regarding PostgreSQL? Also, any links to benchmarking tests available on the interne

[PERFORM] How to time several queries?

2004-10-18 Thread nd02tsk
Hello I posted this on the general list but think it would be more appropriate here. Sorry. I know it is possible to time isolated queries through the settting of the \timing option in psql. This makes PgSQL report the time it took to perform one operation. I would like to know how one can get a

Re: [PERFORM] How to time several queries?

2004-10-20 Thread nd02tsk
It doesn't seem to work. I want a time summary at the end. I am inserting insert queries from a file with the \i option. This is the outcome: [7259] LOG: statement: INSERT INTO weather VALUES ('San Francisco', 46, 50, 0.25, '1994-11-27'); [7259] LOG: duration: 1.672 ms [7259] LOG: statement: I

Re: [PERFORM] Which plattform do you recommend I run PostgreSQL

2004-10-20 Thread nd02tsk
Thank you. Tim > hi, > > [EMAIL PROTECTED] wrote: >> Hello >> >> I am doing a comparison between MySQL and PostgreSQL. >> >> In the MySQL manual it says that MySQL performs best with Linux 2.4 with >> ReiserFS on x86. Can anyone official, or in the know, give similar >> information regarding Post