Re: [GENERAL] PostgreSQL advocacy

2016-03-26 Thread Albe Laurenz
Jernigan, Kevin wrote: >On 3/24/16, 3:09 PM, "Albe Laurenz" wrote: >>> Disk is only a single point of failure in RAC if you configure >>> non-redundant storage. >>> In general, Oracle recommends triple mirroring to protect against disk >>> failures, >>> as they have had many experiences over the

Re: [GENERAL] PostgreSQL advocacy

2016-03-25 Thread Mark Morgan Lloyd
Jernigan, Kevin wrote: On 3/25/16, 4:37 AM, "pgsql-general-ow...@postgresql.org on behalf of Mark Morgan Lloyd" wrote: Just because a corporate has a hundred sites cooperating for inventory management doesn't mean that the canteen menus have to be stored on Oracle RAC :-) Right, but ofte

Re: [GENERAL] PostgreSQL advocacy

2016-03-25 Thread Kevin Grittner
On Fri, Mar 25, 2016 at 4:15 PM, Jernigan, Kevin wrote: > On 3/25/16, 4:37 AM, "pgsql-general-ow...@postgresql.org on behalf of Mark > Morgan Lloyd" markmll.pgsql-gene...@telemetry.co.uk> wrote: >> Just because a corporate has a hundred sites cooperating for inventory >> management doesn't mean

Re: [GENERAL] PostgreSQL advocacy

2016-03-25 Thread Jernigan, Kevin
On 3/25/16, 4:37 AM, "pgsql-general-ow...@postgresql.org on behalf of Mark Morgan Lloyd" wrote: >Jernigan, Kevin wrote: >> On 3/22/16, 8:07 AM, "Bruce Momjian" wrote: > >>> >>> HA Scaling Upgrade Add/Remove >>>Oracle RAC 50% 50%easyeasy >>>

Re: [GENERAL] PostgreSQL advocacy

2016-03-25 Thread Mark Morgan Lloyd
Jernigan, Kevin wrote: On 3/22/16, 8:07 AM, "Bruce Momjian" wrote: HA Scaling Upgrade Add/Remove Oracle RAC 50% 50%easyeasy Streaming Rep. 100% 25%* hardeasy Sharding 0%100%hardhard

Re: [GENERAL] PostgreSQL advocacy

2016-03-24 Thread Jernigan, Kevin
On 3/22/16, 8:07 AM, "Bruce Momjian" wrote: >On Mon, Mar 21, 2016 at 04:46:51PM +, Jernigan, Kevin wrote: >> Disk is only a single point of failure in RAC if you configure >> non-redundant storage. In general, Oracle recommends triple mirroring >> to protect against disk failures, as they h

Re: [GENERAL] PostgreSQL advocacy

2016-03-24 Thread Jernigan, Kevin
On 3/24/16, 3:09 PM, "Albe Laurenz" wrote: >Jernigan, Kevin wrote: >> Disk is only a single point of failure in RAC if you configure non-redundant >> storage. >> In general, Oracle recommends triple mirroring to protect against disk >> failures, >> as they have had many experiences over the ye

Re: [GENERAL] PostgreSQL advocacy

2016-03-24 Thread Albe Laurenz
Jernigan, Kevin wrote: > Disk is only a single point of failure in RAC if you configure non-redundant > storage. > In general, Oracle recommends triple mirroring to protect against disk > failures, > as they have had many experiences over the years where customers with > mirrored disks > would s

Re: [GENERAL] PostgreSQL advocacy

2016-03-22 Thread Bruce Momjian
On Tue, Mar 22, 2016 at 10:16:22AM -0600, Scott Marlowe wrote: > On Tue, Mar 22, 2016 at 9:15 AM, Thomas Kellerer wrote: > > Bruce Momjian schrieb am 22.03.2016 um 16:07: > >> > >> However, I do think database upgrades are easier with Oracle RAC > > > > I think you can do a rolling upgrade with a

Re: [GENERAL] PostgreSQL advocacy

2016-03-22 Thread Scott Marlowe
On Tue, Mar 22, 2016 at 9:15 AM, Thomas Kellerer wrote: > Bruce Momjian schrieb am 22.03.2016 um 16:07: >> >> However, I do think database upgrades are easier with Oracle RAC > > I think you can do a rolling upgrade with a standby, but I'm not entirely > sure. I find Slony good for upgrading ver

Re: [GENERAL] PostgreSQL advocacy

2016-03-22 Thread Thomas Kellerer
Bruce Momjian schrieb am 22.03.2016 um 16:07: > For me, streaming replication fully solves the high reliability problem > and sharding fully solves the scaling problem. Of course, if you need > both, you have to deploy both, which gives you 100% of two solutions, > rather than Oracle RAC which giv

Re: [GENERAL] PostgreSQL advocacy

2016-03-22 Thread Bruce Momjian
On Mon, Mar 21, 2016 at 04:46:51PM +, Jernigan, Kevin wrote: > Disk is only a single point of failure in RAC if you configure > non-redundant storage. In general, Oracle recommends triple mirroring > to protect against disk failures, as they have had many experiences > over the years where cust

Re: [GENERAL] PostgreSQL advocacy

2016-03-21 Thread Jernigan, Kevin
On 3/21/16, 9:10 AM, "pgsql-general-ow...@postgresql.org on behalf of Rakesh Kumar" wrote: >On 03/21/2016 10:57 AM, Thomas Kellerer wrote: > >> So - at least as far as I can tell - it's usually only used where >> high-availability is really important, e.g. where zero-downtime is required. >> I

Re: [GENERAL] PostgreSQL advocacy

2016-03-21 Thread Rakesh Kumar
On 03/21/2016 10:57 AM, Thomas Kellerer wrote: So - at least as far as I can tell - it's usually only used where high-availability is really important, e.g. where zero-downtime is required. If you can live with a short downtime, a hot standby is much cheaper and probably not that much slower.

Re: [GENERAL] PostgreSQL advocacy

2016-03-21 Thread Scott Marlowe
On Mon, Mar 21, 2016 at 7:44 AM, Mark Morgan Lloyd wrote: > If anybody puts together a "just the facts" document after Oracle's attack > on PostgreSQL in Russia, please make sure it's drawn to the attention of > this mailing list for the benefit of those who aren't in -advocacy. > > I was discussi

Re: [GENERAL] PostgreSQL advocacy

2016-03-21 Thread Thomas Kellerer
Mark Morgan Lloyd schrieb am 21.03.2016 um 14:44: > I was discussing this sort of thing elsewhere in the context of MS's > apparent challenge to Oracle and IBM, and the dominant feeling > appeared to be that actual use of things like Oracle RAC was > vanishingly uncommon. Which surprised me, and wh

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-12-16 Thread Rory Campbell-Lange
On 29/11/03, Randal L. Schwartz ([EMAIL PROTECTED]) wrote: > Well, since I need 2.5 ideas per month for the three columns I'm still > writing, I'm certainly in a position to write nice things about PG, > although I always have to work it in from a Perl slant. > > Actually, I'm sure that any of the

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-12-04 Thread Alex Satrapa
Chris Travers wrote: Here is a paper I have written for the purposes of providing some additional educational material for the MySQL crowd. Here's my contribution: Why I choose PostgreSQL (PostgreSQL in 21 Seconds) I choose referential integrity, meaning my lookups always work. I choose stor

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-12-01 Thread Rick Gigger
ot; <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, November 30, 2003 5:49 AM Subject: Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments > Re: [GENERAL] PostgreSQL Advocacy, Thoughts and CommentsRegarding the > learning curve issue, maybe people can recomme

Re: Triggers, Stored Procedures, PHP. was: Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-12-01 Thread Rick Gigger
Note: I am a php developer and I love it, but... >In dealing with web applications and frontends to database or >even just a dynamic web site PHP has every bit the power and ability that >Java does and the development time is way down. Uh, how about threads. I know that you don't need them much

Re: Triggers, Stored Procedures, PHP. was: Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-12-01 Thread Rick Gigger
aturday, November 29, 2003 10:01 AM Subject: Re: Triggers, Stored Procedures, PHP. was: Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments > "Rod K" <[EMAIL PROTECTED]> writes: > > Paul Thomas wrote: > >> Much of the populatity of MySQL seems to stem from PHPs

Re: Triggers, Stored Procedures, PHP. was: Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-11-30 Thread Paul Thomas
On 29/11/2003 16:24 Jason Tesser wrote: [snip] A programmer that doesn't document stuff needs to find a new job :-) Agreed. So you're replaced him and inherited a documentation-free application. How many favours has he done you by squirrelling away section of business logic in the database? This

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-11-30 Thread Tony
Title: Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments Comments within: Chris Travers wrote: Tony <[EMAIL PROTECTED]> Wrote: Now many consultant/developer/sys-admins like myself are going to client site on a contract (this is especially true in the UK, I can'

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-11-30 Thread Chris Travers
Tony <[EMAIL PROTECTED]> Wrote: > Now many > consultant/developer/sys-admins like myself are going to client site on > a contract (this is especially true in the UK, I can't speak for > anywhere else) and finding complex stocktrading systems, inventory > systems, CRM systems, and others, all writt

Re: Triggers, Stored Procedures, PHP. was: Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-11-29 Thread Chris Travers
From: "Paul Thomas" <[EMAIL PROTECTED]>: > Stored procedures can be a 2-edged sword. They can lead to business logic > being scattered between the persistence layer and the business layer. > Thats not good for maintaining the application 3 years down the line. > Triggers can also cause maintenance

Re: Triggers, Stored Procedures, PHP. was: Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-11-29 Thread Rod K
Paul Thomas wrote: > > > > On 28/11/2003 17:10 Jason Tesser wrote: > > [snip] > > > > MySQL cannot even handle > > sub-queries yet. I also use Python for standalone interfaces to > the data. > > > > Why should I not be able to use the same views and triggers etc > in there > > that I use for my

Triggers, Stored Procedures, PHP. was: Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-11-29 Thread Paul Thomas
On 28/11/2003 17:10 Jason Tesser wrote: [snip] I completely disagree. I do a lot of programming with PHP and the features of Postgres come in handy. Let me give you an example of just some basic things. Triggers! Why should I have to write insert and update triggers in the logic (PHP) if I can

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-11-29 Thread Unihost Web Hosting
Further to this post, what might actually work is to convince O' Reilly (since they have PostgreSQL book/s) to do some articles like they have for PG, but making full use of the PG database. For instance, building a simple data-warehouse using PG. Articles that show off an OSS product/project

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-11-29 Thread Tony
HI All, I'm glad that this thread prompted some thoughtful response. I think one of my main points I was trying to make, Jason hit the nail on the head. The article to which I was referring uses a great example which I have experienced many times before, but in order to grasp this, PHP et a

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-11-29 Thread Oliver Elphick
On Sat, 2003-11-29 at 04:37, cnliou wrote: > "Jason Tesser" <[EMAIL PROTECTED]> > > > MySQL cannot even handle sub-queries yet. > > Ohh! Really? > Allow me to pay my highest respect to the genius mySQL > programmers! > I completely have no clue on how to construct any single > tiny database on

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-11-28 Thread Chris Travers
"Jason Tesser" <[EMAIL PROTECTED]> wrote: > I completely disagree. I do a lot of programming with PHP and the features > of Postgres come in handy. Let me give you an example of just some > basic things. Triggers! Why should I have to write insert and update > triggers in the logic (PHP) if I c

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-11-28 Thread cnliou
"Jason Tesser" <[EMAIL PROTECTED]> > MySQL cannot even handle sub-queries yet. Ohh! Really? Allow me to pay my highest respect to the genius mySQL programmers! I completely have no clue on how to construct any single tiny database on a DBMS having no sub-query capability. Being too dumb, I sol

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-11-28 Thread Jason Tesser
hi, > Maybe there's not such a need for the advanced features of PostgreSQL > amongst PHP programmers as you seem to believe. Most of the PHP stuff I've > seen is read-only content display stuff and that doesn't really require a > top-notch RDBMS; a more limited database should also be up to

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

2003-11-28 Thread Paul Thomas
On 27/11/2003 09:19 Tony wrote: Hi All, I've just been reading an article in PHP Architect magazine (http://www.phparch.com) which is the cover story for October called "Migrating from MySQL to PostgreSQL". I must say that this is a highly compelling article, especially for me, and is aimed a