Postgres Pro
Downloads
Home   >   mailing lists

Re: Millions of tables - Mailing list pgsql-performance

From Greg Spiegelberg
Subject Re: Millions of tables
Date
Msg-id CAEtnbpVPrQebE===N0pTwWseRKLm5Z6dB212r1OJe3VVv3prsg@mail.gmail.com
Whole thread Raw
In response to Re: Millions of tables  (Vitalii Tymchyshyn <vit@tym.im>)
List pgsql-performance
Tree view
On Wed, Sep 28, 2016 at 9:39 AM, Vitalii Tymchyshyn <vit@tym.im> wrote:
Have you considered having many databases (e.g. 100) and possibly many postgresql servers (e.g. 10) started on different ports?
This would give you 1000x less tables per db.

The system design already allows for many database servers.  40 is okay, 100 isn't terrible but if it's thousands then operations might lynch me.

-Greg

pgsql-performance by date:

Previous
From: Richard Albright
Date:
Subject: Re: Millions of tables
Next
From: Stephen Frost
Date:
Subject: Re: Millions of tables