Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2 - Mailing list pgsql-performance

From Olivier Andreotti
Subject Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2
Date
Msg-id d5d40b330605180359w5c79beb6lc0426820911f55d1@mail.gmail.com
Whole thread Raw
In response to Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2  ("Olivier Andreotti" <olivier.andreotti@gmail.com>)
List pgsql-performance
>
> 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.

> > shared_buffer = 16384
>
> This may be higher.
>

I'll try that.


> > autovaccuum = on
>
> And you are sure, it's running?
>

Yes, i can see autovaccum in the postgresql.log.

pgsql-performance by date:

Previous
From: Jean-Paul Argudo
Date:
Subject: Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle
Next
From: Guido Neitzer
Date:
Subject: Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle