Forums / Suggestions / PostgreSQL support, is it a yes or no?

PostgreSQL support, is it a yes or no?

Author Message

henrik gudat

Wednesday 18 July 2007 5:51:10 am

Hi,

we are about to start migrating a major web site to eZ Publish. We have selected this system not only because of its obviously great feature set in the front row but also because it has, or better had, official support for PostgreSQL. I do not want to enter the eternal PostgreSQL vs. MySQL vs. you name it, but I think it's all but fair to say that PostgreSQL is a decent database. It is our favourite database for the reason alone that we are running a big system on postgres already and only want to do database maintenance once.

I now read in the Community Newsletter that eZ Systems decided to remove PostgreSQL clustering support. This is, to be precise, the end of PostgreSQL in eZ Publish.

Clustering support is essential for keeping scalability of a system. Without such a growth path, eZ Publish is out of the loop for anything that may ever outgrow a single server setup. (I understand there may be workarounds, but IMHO only database-side clustering is a clean solution.)

I have gotten very mixed messages about PostgreSQL commitment in the past, and this is not good for eZ's marketing and planning on everyone else's end. It would be tremendously helpful to get rid off these uncertainties by either ending support for PostgreSQL or making it a full-blown option to MySQL. For me both would work (though I obviously prefer PostgreSQL for maintenance, hardware utilization reasons and personal affection), but the worst that can happen when inmidst of production such an essential feature is breaking away and you have to redo your infrastructure only because of this. To get back to the title, I think it should be either a clear yes or no because anything in between just adds to the confusion.

I would love to hear what others think about this.

regards,
henrik

Vidar Langseid

Friday 17 August 2007 8:20:11 am

Hi

Without a doubt, the big majority of eZ Publish users are using Mysql as database. However, some are also using PostgreSQL or Oracle. We will therefore still support these databases

However, the number of sites out there running PostgreSQL with *clustering* is very very low. At the time of writing I am not aware of anyone who are using it, neither community members or customers.

In 3.10 we have have used quite much effort in fixing issues in the mysql clustering code. During this work it became apparent that doing the same with PostgreSQL and Oracle would require just as much effort per port as we spent on the Mysql solution. The solution now is very Innodb specific. Since the use of clustering with PostgreSQL is effectively non-existent we chose as we did. Ending clustering support in oracle was a harder choice though since this is infact used, but by a very few.

We may then later consider reintroducing cluster support on postgresql when we are on PHP5 and are using the database component in eZ Components.

Best regards,
Vidar L

eZ debug

Timing: Jan 18 2025 04:09:29
Script start
Timing: Jan 18 2025 04:09:29
Module start 'content'
Timing: Jan 18 2025 04:09:30
Module end 'content'
Timing: Jan 18 2025 04:09:30
Script end

Main resources:

Total runtime0.9104 sec
Peak memory usage4,096.0000 KB
Database Queries191

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0056 587.8125180.8281
Module start 'content' 0.00570.7980 768.6406468.7188
Module end 'content' 0.80370.1066 1,237.3594335.3047
Script end 0.9103  1,572.6641 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00390.4311210.0002
Check MTime0.00150.1650210.0001
Mysql Total
Database connection0.00070.072510.0007
Mysqli_queries0.852993.69351910.0045
Looping result0.00160.18031890.0000
Template Total0.883397.020.4416
Template load0.00180.197720.0009
Template processing0.881596.829220.4407
Template load and register function0.00020.027110.0002
states
state_id_array0.00050.054110.0005
state_identifier_array0.00070.077020.0004
Override
Cache load0.00150.1602190.0001
Sytem overhead
Fetch class attribute can translate value0.00140.154330.0005
Fetch class attribute name0.00150.164320.0007
XML
Image XML parsing0.00050.052530.0002
class_abstraction
Instantiating content class attribute0.00000.001120.0000
General
dbfile0.00260.2851210.0001
String conversion0.00000.000730.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
2content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
4content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
2content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 10
 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs