Re: [GENERAL] PostgreSQL advocacy

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

Re: [GENERAL] PostgreSQL advocacy

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

Re: [GENERAL] PostgreSQL advocacy

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: > >>> >>>

Re: [GENERAL] PostgreSQL advocacy

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%hard

Re: [GENERAL] PostgreSQL advocacy

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

Re: [GENERAL] PostgreSQL advocacy

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

Re: [GENERAL] PostgreSQL advocacy

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

Re: [GENERAL] PostgreSQL advocacy

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

Re: [GENERAL] PostgreSQL advocacy

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

Re: [GENERAL] PostgreSQL advocacy

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

Re: [GENERAL] PostgreSQL advocacy

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

Re: [GENERAL] PostgreSQL advocacy

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 >>

Re: [GENERAL] PostgreSQL advocacy

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

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

Re: [GENERAL] PostgreSQL advocacy

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

[GENERAL] PostgreSQL advocacy

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 discussing this sort of thing elsewhere in the context of MS's

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

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

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

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

, 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 out-of-the-box support for it. This is incorrect. The embedded mysql client library

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

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: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

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 recommend their favorite books. I recommend SQL Unleashed (I forget

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

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 written in

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

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't speak

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

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?

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

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 a DBMS having

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

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

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

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

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

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

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

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 web apps. PHP is

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

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: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

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 at

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

hi, huge snip 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

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

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 solicit

Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments

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 can

[GENERAL] PostgreSQL Advocacy, Thoughts and Comments

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 at programmers that aren't

[GENERAL] PostgreSQL Advocacy Fund and New Banner Ads

POSTGRESQL ADVOCACY FUND Robert Treat has been selected by the Core Team as Treasurer for our new PostgreSQL Advocacy Fund. Robert will soon be setting up an account in the U.S. for receiving donations for the promotion of PostgreSQL. This fund will be used primarily to print promotional