Re: Experience with large number of tables in single PostgreSQL instance

From: Vedran Krivokuca <vkrivokuca(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Experience with large number of tables in single PostgreSQL instance
Date: 2013-04-10 07:10:59
Message-ID: CAP+XhHsry4DinX+2eNSdrgD2NLpV8tHpJoC8rDTPQ7gqMYxnWQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Apr 10, 2013 at 9:07 AM, Vedran Krivokuca <vkrivokuca(at)gmail(dot)com> wrote:
> 1) we can go with different instances of PostgreSQL service, let's say
> (for pure theory) 10 of them on the same HA cluster setup. Every
> instance would hold let's say 1/10th of that big recordset, and around
> 3.000 database tables (this apparently shouldn't be of any problem to
> PostgreSQL, see below).

I am talking shit here, obviously, excuse me. We would go with, for
example, 10 or 100 databases in the same PostgreSQL instance.
Buzzwording got better of me. :) The rest of my initial e-mail still
applies, I will cherish any input of experience on this subject.

V.

--
Pozdrav/Greetings,
Vedran Krivokuća
Disclaimer: This message may contain information.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Vasilis Ventirozos 2013-04-10 07:24:50 Re: Experience with large number of tables in single PostgreSQL instance
Previous Message Vedran Krivokuca 2013-04-10 07:07:10 Experience with large number of tables in single PostgreSQL instance