Re: Thousands databases or schemas

From: Craig Ringer <craig(at)2ndQuadrant(dot)com>
To: Denis <socsam(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Thousands databases or schemas
Date: 2012-11-09 06:15:45
Message-ID: 509C9F91.4020902@2ndQuadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 11/08/2012 09:29 PM, Denis wrote:
> Ok guys, it was not my intention to hurt anyone's feelings by mentioning
> MySQL. Sorry about that.
It's pretty silly to be upset by someone mentioning another DB product.
I wouldn't worry.
> There simply was a project with a similar
> architecture built using MySQL. When we started the current project, I have
> made a decision to give PostgreSQL a try.
It's certainly interesting that MySQL currently scales to much larger
table counts better than PostgreSQL appears to.

I'd like to see if this can be improved down the track. Various people
are doing work on PostgreSQL scaling and performance, so with luck huge
table counts will come into play there. If nothing else, supporting
large table counts is important when dealing with very large amounts of
data in partitioned tables.

I think I saw mention of better performance with higher table counts in
9.3 in -hackers, too.

> I would recommend you to refresh the info here
> http://wiki.postgresql.org/wiki/FAQ. There is a question "What is the
> maximum size for a row, a table, and a database?". Please add there info on
> maximum DBs number and tables number one DB can contain while PostgreSQL
> continues to work properly.
Yeah, a number of people have been thrown by that. Technical limitations
aren't the same as practical limitations, and in some cases the
practical limitations are lower.

The trouble is: How do you put a number to it when something is a slow
and gradual drop in performance? And when one person's "performs
adequately" is another's "way too slow" ?

--
Craig Ringer

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Magnus Hagander 2012-11-09 06:38:22 Re: Thousands databases or schemas
Previous Message Petr Praus 2012-11-08 18:23:03 Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries