Postgres version in Servoy Installation

Questions and answers for all installation-related topics for Servoy products

Postgres version in Servoy Installation

Postby ashutoslenka426 » Mon Mar 11, 2013 11:07 am

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.
AL
ashutoslenka426
 
Posts: 295
Joined: Thu Jan 26, 2012 3:38 pm

Re: Postgres version in Servoy Installation

Postby Ruben79 » Mon Mar 11, 2013 4:34 pm

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.
Ruben de Jong
Stb Software Development
SAN Partner

Stb Software Development - http://www.stb.nl
User avatar
Ruben79
 
Posts: 97
Joined: Wed Apr 18, 2007 12:43 pm

Re: Postgres version in Servoy Installation

Postby ROCLASI » Tue Mar 12, 2013 3:54 am

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.
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: Postgres version in Servoy Installation

Postby ashutoslenka426 » Tue Mar 12, 2013 7:40 am

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.
AL
ashutoslenka426
 
Posts: 295
Joined: Thu Jan 26, 2012 3:38 pm

Re: Postgres version in Servoy Installation

Postby Ruben79 » Tue Mar 12, 2013 1:01 pm

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):
Code: Select all
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
Ruben de Jong
Stb Software Development
SAN Partner

Stb Software Development - http://www.stb.nl
User avatar
Ruben79
 
Posts: 97
Joined: Wed Apr 18, 2007 12:43 pm


Return to Installation

Who is online

Users browsing this forum: No registered users and 5 guests

cron