Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group