pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL isn't enough scalable as Oracle or DB2
4+ messages / 3 participants
[nested] [flat]
* PostgreSQL isn't enough scalable as Oracle or DB2
@ 2014-04-21 18:45 Oscar Calderon <ocalderon@solucionesaplicativas.com>
2014-04-21 19:23 ` Re: PostgreSQL isn't enough scalable as Oracle or DB2 Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Oscar Calderon @ 2014-04-21 18:45 UTC (permalink / raw)
To: pgsql-admin
Hi, have a nice day. I'm reading about PostgreSQL Architecture Fundamentals
for taking the Associate Exam, and i found this article:
http://reshmaparveen.blogspot.com/2009/12/postgresql-system-architecture.html
I was reading the Scalability section, where it mentions this:
*Even though the query receiving thread is alone it still offers better or
equal scalability to MySQL. In terms of multi-computer scalability,
PostgreSQL does not scale at all. For large cluster based clustering,
commercial database systems are by far more mature; some good
implementations include Oracle and DB2.*
The article is from 2009 and i know that PostgreSQL has been getting better
and better but i don't know if this is true or if this have been surpassed
or if it was a lie.
Regards.
***************************
Oscar Calderon
Analista de Sistemas
Soluciones Aplicativas S.A. de C.V.
www.solucionesaplicativas.com
Cel. (503) 7741 7850 Tel. (503) 2522-2834
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: PostgreSQL isn't enough scalable as Oracle or DB2
2014-04-21 18:45 PostgreSQL isn't enough scalable as Oracle or DB2 Oscar Calderon <ocalderon@solucionesaplicativas.com>
@ 2014-04-21 19:23 ` Scott Marlowe <scott.marlowe@gmail.com>
2014-04-21 20:53 ` Re: PostgreSQL isn't enough scalable as Oracle or DB2 Korry Douglas <korry.douglas@enterprisedb.com>
0 siblings, 1 reply; 4+ messages in thread
From: Scott Marlowe @ 2014-04-21 19:23 UTC (permalink / raw)
To: Oscar Calderon <ocalderon@solucionesaplicativas.com>; +Cc: pgsql-admin
On Mon, Apr 21, 2014 at 12:45 PM, Oscar Calderon
<ocalderon@solucionesaplicativas.com> wrote:
> http://reshmaparveen.blogspot.com/2009/12/postgresql-system-architecture.html
>
> I was reading the Scalability section, where it mentions this:
>
> Even though the query receiving thread is alone it still offers better or
> equal scalability to MySQL. In terms of multi-computer scalability,
> PostgreSQL does not scale at all.
This statement was wrong in 2009 and it's still wrong today. We were
using slony well before 2009 with read slaves to handle massive read
loads. While muti-master setups are still pretty new in the PostgreSQL
universe, there are some seups like Bucardo. Of course this paper
doesn't mention whether or not they're referring to shared storage or
separate storage, and what kind of loads would be expected. RedHat
Cluster server can provide failover etc. There are several different
options that pre-date this article.
The fact that it then goes on the sing the praises of MySQL clusters
as reliable and stable makes me question the whole article.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: PostgreSQL isn't enough scalable as Oracle or DB2
2014-04-21 18:45 PostgreSQL isn't enough scalable as Oracle or DB2 Oscar Calderon <ocalderon@solucionesaplicativas.com>
2014-04-21 19:23 ` Re: PostgreSQL isn't enough scalable as Oracle or DB2 Scott Marlowe <scott.marlowe@gmail.com>
@ 2014-04-21 20:53 ` Korry Douglas <korry.douglas@enterprisedb.com>
2014-04-21 22:39 ` Re: PostgreSQL isn't enough scalable as Oracle or DB2 Oscar Calderon <ocalderon@solucionesaplicativas.com>
0 siblings, 1 reply; 4+ messages in thread
From: Korry Douglas @ 2014-04-21 20:53 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: Oscar Calderon <ocalderon@solucionesaplicativas.com>; pgsql-admin
>> http://reshmaparveen.blogspot.com/2009/12/postgresql-system-architecture.html
>>
>> I was reading the Scalability section, where it mentions this:
>>
>> Even though the query receiving thread is alone it still offers better or
>> equal scalability to MySQL. In terms of multi-computer scalability,
>> PostgreSQL does not scale at all.
> This statement was wrong in 2009 and it's still wrong today. We were
> using slony well before 2009 with read slaves to handle massive read
> loads. While muti-master setups are still pretty new in the PostgreSQL
> universe, there are some seups like Bucardo. Of course this paper
> doesn't mention whether or not they're referring to shared storage or
> separate storage, and what kind of loads would be expected. RedHat
> Cluster server can provide failover etc. There are several different
> options that pre-date this article.
>
> The fact that it then goes on the sing the praises of MySQL clusters
> as reliable and stable makes me question the whole article.
>
>
And, the page mentioned above seems to be copied verbatim (and without
attribution) from a 2004 paper here:
http:// www.benjaminarai.com/downloads/whitepapers/postgresql.doc
-- Korry
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: PostgreSQL isn't enough scalable as Oracle or DB2
2014-04-21 18:45 PostgreSQL isn't enough scalable as Oracle or DB2 Oscar Calderon <ocalderon@solucionesaplicativas.com>
2014-04-21 19:23 ` Re: PostgreSQL isn't enough scalable as Oracle or DB2 Scott Marlowe <scott.marlowe@gmail.com>
2014-04-21 20:53 ` Re: PostgreSQL isn't enough scalable as Oracle or DB2 Korry Douglas <korry.douglas@enterprisedb.com>
@ 2014-04-21 22:39 ` Oscar Calderon <ocalderon@solucionesaplicativas.com>
0 siblings, 0 replies; 4+ messages in thread
From: Oscar Calderon @ 2014-04-21 22:39 UTC (permalink / raw)
To: Korry Douglas <korry.douglas@enterprisedb.com>; +Cc: Scott Marlowe <scott.marlowe@gmail.com>; pgsql-admin
Ahh ok, yeah both emails are very useful. I also thought about replication
but because in the article is covered as a separated topic i thought that
it had nothing to do with scalability.
Regards and thanks.
***************************
Oscar Calderon
Analista de Sistemas
Soluciones Aplicativas S.A. de C.V.
www.solucionesaplicativas.com
Cel. (503) 7741 7850 Tel. (503) 2522-2834
2014-04-21 14:53 GMT-06:00 Korry Douglas <korry.douglas@enterprisedb.com>:
>
>
>
> http://reshmaparveen.blogspot.com/2009/12/postgresql-system-architecture.html
>
> I was reading the Scalability section, where it mentions this:
>
> Even though the query receiving thread is alone it still offers better or
> equal scalability to MySQL. In terms of multi-computer scalability,
> PostgreSQL does not scale at all.
>
> This statement was wrong in 2009 and it's still wrong today. We were
> using slony well before 2009 with read slaves to handle massive read
> loads. While muti-master setups are still pretty new in the PostgreSQL
> universe, there are some seups like Bucardo. Of course this paper
> doesn't mention whether or not they're referring to shared storage or
> separate storage, and what kind of loads would be expected. RedHat
> Cluster server can provide failover etc. There are several different
> options that pre-date this article.
>
> The fact that it then goes on the sing the praises of MySQL clusters
> as reliable and stable makes me question the whole article.
>
>
>
> And, the page mentioned above seems to be copied verbatim (and without
> attribution) from a 2004 paper here:
>
> http:// www.benjaminarai.com/downloads/whitepapers/postgresql.doc
>
>
> -- Korry
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2014-04-21 22:39 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-04-21 18:45 PostgreSQL isn't enough scalable as Oracle or DB2 Oscar Calderon <ocalderon@solucionesaplicativas.com>
2014-04-21 19:23 ` Scott Marlowe <scott.marlowe@gmail.com>
2014-04-21 20:53 ` Korry Douglas <korry.douglas@enterprisedb.com>
2014-04-21 22:39 ` Oscar Calderon <ocalderon@solucionesaplicativas.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox