Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2

From: "Olivier Andreotti" <olivier(dot)andreotti(at)gmail(dot)com>
To: "Guido Neitzer" <guido(dot)neitzer(at)pharmaline(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2
Date: 2006-05-18 10:59:42
Message-ID: d5d40b330605180359w5c79beb6lc0426820911f55d1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Guido Neitzer 2006-05-18 11:02:29 Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle
Previous Message Gregory S. Williamson 2006-05-18 10:55:32 Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2