how to increase speed of PostgreSQL db?

Classic Servoy
1

I changed for an existing solution from Sybase 11 to PostgreSQL 8.4.
The Average Time in Performance Data of the PostgreSQL db on the servoy-admin site is about 10 times higher in comparison to the Sybase 11 db!? This means that my solution is about 10 times faster with the Sybase 11 db!
The only “performance tuning” I made in Sybase was creating idexes in the Sybase Central tool. The PostgreSQL 8.4 db server is “untought” and running as installed.
How could I optimize (should I?) the PostgreSQL db for a better performance?

Thanks in advance,
Thomas

Servoy 5.2.1
PostgreSQL 8.4.4
Mac OSX 10.6.4
Java 1.6_20

2

Hi Thomas,

What database are you talking about ? The Servoy repository? Or some of your own databases ?

3

Hi Robert,

I’m talking about my own databases.

4

Hi Thomas,

Then you need to apply indices in places that needs it. Servoy doesn’t apply those (because there is no standard way of doing that, in fact indices are not in the SQL standard).
PgAdmin allows you create indices on columns. Just go into the tree and right-click on the indexes node you find under the table node.

Hope this helps.

5

Ok, I’m just trying to create indexes for each table in my PostgreSQL db. It seems to be similar to Sybase…
I will post a reply how does it changes the db speed.

Thomas