Re: Millions of tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Sep 28, 2016 at 9:39 AM, Vitalii Tymchyshyn <vit@xxxxxx> 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

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux