dbTalk Databases Forums  

Tuning efforts and versions

comp.databases.postgresql comp.databases.postgresql


Discuss Tuning efforts and versions in the comp.databases.postgresql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mladen Gogala
 
Posts: n/a

Default Tuning efforts and versions - 02-01-2010 , 10:35 AM






I am stuck to Postgres 8.3 because there is no pljava for the version
8.4, at least not in the RPM form. There are significant changes in 8.4.2
with respect to background writer and asynchronous writes. In particular,
there is a parameter effective_io_concurrency documented here:

http://www.postgresql.org/docs/curre...-resource.html

This works on Postgres 8.4.2 and has a visible effect on large data loads
and index creation. Is there a possibility of back-porting this to 8.3?
Alternatively, when can I expect pljava package for version 8.4?



--
http://mgogala.byethost5.com

Reply With Quote
  #2  
Old   
Thomas Kellerer
 
Posts: n/a

Default Re: Tuning efforts and versions - 02-01-2010 , 01:08 PM






Mladen Gogala wrote on 01.02.2010 17:35:
Quote:
This works on Postgres 8.4.2 and has a visible effect on large data loads
and index creation. Is there a possibility of back-porting this to 8.3?
Definitely not.

New features are *never* introduced with minor upgrades
Or to put the other way round: minor upgrades *only* include bug fixes, never introduce _new_ stuff

Thomas

Reply With Quote
  #3  
Old   
Mladen Gogala
 
Posts: n/a

Default Re: Tuning efforts and versions - 02-01-2010 , 01:34 PM



On Mon, 01 Feb 2010 20:08:58 +0100, Thomas Kellerer wrote:

Quote:
Mladen Gogala wrote on 01.02.2010 17:35:
This works on Postgres 8.4.2 and has a visible effect on large data
loads and index creation. Is there a possibility of back-porting this
to 8.3?

Definitely not.

New features are *never* introduced with minor upgrades Or to put the
other way round: minor upgrades *only* include bug fixes, never
introduce _new_ stuff

Thomas
Bummer! I hope that pljava package for 8.4.2 will be released soon.



--
http://mgogala.byethost5.com

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.