Re: How to manage/tune PostGres - Mailing list pgsql-admin

From Goulet, Dick
Subject Re: How to manage/tune PostGres
Date
Msg-id 4001DEAF7DF9BD498B58B45051FBEA6506D913@25exch1.vicorpower.vicr.com
Whole thread Raw
In response to How to manage/tune PostGres  (Philippe Lefevre <philippe.lefevre@barclays.co.uk>)
List pgsql-admin
Philippe,

    First off, welcome to the club.  We're primarily an Oracle shop, but due to Oracle's pricing we are using
PostGreSqlfor web based applications. 

    Why PostGreSql.  Well first off it provides a much smaller learning curve for our developers than MySql does.
MySql,until this last iteration, did not support stored procedures, packages, triggers, etc.....  PostGreSql does and
withthe simple "create language plpgsql" command and one additional line in the Oracle procedure it works in PostGreSql
justfine.  PostGreSql can also be backed up hot, pg_dump, whereas MySql has to be shutdown.  PostGreSql likes Java
storedprocedures, little bit more work to get initially setup, but then after your Oracle Java procedures move over
almosteffortlessly.  Again PostGreSql handles data in a very similar fashion to Oracle.  Read consistent view is there,
don'tcount on that with MySql without the add on. 

    So if you or your boss is looking for a comparison it kinda falls like this:

    Open Source        Commercial equivalent

    PostGreSql        Oracle
    MySql            Sql*Server or more appropriately Access.

BTW: the admin and tuning needs on PostGreSql appear to be less than Oracle, that is assuming you've setup Oracle in
theusual non intelligent way. 

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: Philippe Lefevre [mailto:philippe.lefevre@barclays.co.uk]
Sent: Wednesday, January 14, 2004 5:10 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] How to manage/tune PostGres


Hello all,

My company mainly use Oracle as database but we would like to make some
tries with some open source database.
I think PostGreSQL might be candidate for our project.
I read several documents on it, but I wasn't able to find any infos on what
are exactly the needs, in term of administration,
and, if any, how to manage/tune that database in a production context. Are
there any graphical tools to do this ?
(like OEM for example)
MySQL, an other open source database, is available. What are the reasons
that makes me happy to put my choice on PostGreSQL ?
Thank you in advance for any info.
PhL



Internet communications are not secure and therefore the Barclays Group
does not accept legal responsibility for the contents of this message.
Although the Barclays Group operates anti-virus programmes, it does not
accept responsibility for any damage whatsoever that is caused by
viruses being passed.  Any views or opinions presented are solely those
of the author and do not necessarily represent those of the Barclays
Group.  Replies to this email may be monitored by the Barclays Group
for operational or business reasons.


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

pgsql-admin by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Trouble connecting
Next
From: Warren Little
Date:
Subject: setting statement_timeout on live postmaster