On Thu, May 18, 2006 at 12:48:42PM +0200, Jean-Paul Argudo wrote:
> > autovaccuum = on
>
> Thats a critic point. Personaly I dont use autovacuum. Because I just
> don't want a vacuum to be started ... when the server is loaded :)
>
> I prefer control vacuum process, when its possible (if its not,
On Thu, May 18, 2006 at 02:44:40PM +0200, Chris Mair wrote:
> Yes, pg_xlog ist also used with fsync=off. you might gain quite some
> performance if you can manage to put pg_xlog on its own disk (just
> symlink the directory).
Substantially increasing wal buffers might help too.
--
Jim C. Nasby,
"Olivier Andreotti" <[EMAIL PROTECTED]> writes:
> Just a last question about the pg_xlog : i understand that the
> directory must be moved but i have just 3 disks for the database :
> disk 1 and 2 for the data, disk 3 for the indexes, where can i put the
> pg_xlog ?
If you have three disks then pu
Hello everybody !
Thanks for all the advices, iI will try all theses new values, and
i'll post my final values on this thread.
About the benchmark and the results, i dont know if can publish values
about Oracle performance ? For MySQL and PostgreSQL, i think there is
no problems.
Just a last qu
"Mikael Carneholm" <[EMAIL PROTECTED]> writes:
> Btw, check you logfile for hints regarding increasing max_fsm_pages, and
> consider increasing checkpoint_segments as well. You could also play
> with more aggressive bgwriter_* params to reduce the risk for long
> vacuum pauses.
Yeah, checkpoint_se
mance@postgresql.org
Subject: [PERFORM] Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle
10g2
Hello,
I'm running a benchmark with theses 3 databases, and the first results
are not very good for PostgreSQL.
PostgreSQL is 20% less performance than MySQL (InnoDB tables)
My benchmark uses the same
> > Could you give us some more infos about the box' performance while you
> > run the PG benchmark? A few minutes output of "vmstat 10" maybe? What
> > does "top" say?
>
> >
> Here, an extract from the vmstat 3 during the test, you can see that
> my problem is probably a very high disk usage (wr
On 18.05.2006, at 12:42 Uhr, Olivier Andreotti wrote:
I use prepared statements for all requests. Each transaction is about
5-45 requests.
This may lead to bad plans (at least with 8.0.3 this was the
case) ... I had the same problem a couple of months ago and I
switched from prepared state
Do you use prepared statements through JDBC with bound variables? If
yes, you might have problems with PostgreSQL not choosing optimal
plans because every statement is planned "generically" which may
force PostgreSQL not to use indexes.
i used prepared statements for the 3 databases.
> share
Hi Olivier,
First question I'd like to ask is: will this benchmark and its results
will be accessible on the net when you'll have finished ?
I'm interested about your benchmark and your results.
> I'm running a benchmark with theses 3 databases, and the first results
> are not very good for Post
To: pgsql-performance@postgresql.org
Cc:
Subject: [PERFORM] Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle
10g2
Hello,
I'm running a benchmark with theses 3 databases, and the first results
are not very good for PostgreSQL.
PostgreSQL is 20% less performance than MySQL
2006/5/18, Chris Mair <[EMAIL PROTECTED]>:
Hello :)
Hello Chris
What version would PostgreSQL 8.1.4 be?
Hum, ok, it is the 8.1.3 version :)
Could you give us some more infos about the box' performance while you
run the PG benchmark? A few minutes output of "vmstat 10" maybe? What
does "
Hello :)
What version would PostgreSQL 8.1.4 be?
> I'm running a benchmark with theses 3 databases, and the first results
> are not very good for PostgreSQL.
Could you give us some more infos about the box' performance while you
run the PG benchmark? A few minutes output of "vmstat 10" maybe? Wh
Hello,
I'm running a benchmark with theses 3 databases, and the first results
are not very good for PostgreSQL.
PostgreSQL is 20% less performance than MySQL (InnoDB tables)
My benchmark uses the same server for theses 3 databases :
Dell Power edge - Xeon 2.8 Ghz - 2 Go Ram - 3 SCSI disks - Deb
14 matches
Mail list logo
