Postgres version in Servoy Installation

Classic Servoy
1

Hi All,

I have installed Servoy 6.1 Application server . I have selected the Postgres Standard server installation in its installation . The default postgres version came out to be 9.0 . The latest postgres version is 9.2.3 . Is Postgres 9.0 best suited for Servoy application server 6.1 ?. Will it provide the best performance ? . Or can I go for postgres 9.2 ? . Why the default is 9.0 ? . Please provide some information on this.

Please provide your suggestions.

Thanks,
Ashutos.

2

I don’t know why PostgreSQL 9.0 is bundled with Servoy, but I am using a separately installed 9.2 PostgreSQL and it works like a charm.

3

Hi Ashutos,

Servoy can work with any RDBMS version that has a proper JDBC driver. So that means you can use Servoy with any version of PostgreSQL as long as you use a recent driver.
If you are not sure if Servoy comes bundled with the latest PostgreSQL driver then you can download one from http://jdbc.postgresql.org/download.html and place that in the drivers directory.
Just make sure this directory only holds one PostgreSQL driver.

Hope this helps.

4

Hi Robert,

Thanks for your reply . Will postgres 9.2 give better performance in comparision to postgres 9.0 ? . In terms of CPU and memory usage ?.

Thanks,
Ashutos.

5

According to the PostgreSQL 9.2 release notes, yes the performance is better as opposed to earlier versions.
There is no reason to use an older version of PostgreSQL in combination with Servoy.

However, tuning your PostgreSQL is mandatory if you want it to make good use of the available resources. By default it will use minimal resources for maximum compatibility.
See this page on the wiki for more info.

In general we stick to these guides (data\postgresql.conf):

shared_buffers: 512Mb to 8Gb
checkpoint_segments: 16 to 256
effective_cache_size: typically 1/2 or 3/4 RAM
work_mem: memory / connections / 4 to 32