Postgres Pro
Downloads
Home   >   mailing lists

Re: Millions of tables - Mailing list pgsql-performance

From Richard Albright
Subject Re: Millions of tables
Date
Msg-id CA+iZHvng=YiG5vQcw7E8UndEZkvbTWenkapq8cMVFXqFxRRUwA@mail.gmail.com
Whole thread Raw
In response to Re: Millions of tables  (Vitalii Tymchyshyn <vit@tym.im>)
List pgsql-performance
Tree view
If going that route, why not just use plproxy?

On Wed, Sep 28, 2016 at 11: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.


pgsql-performance by date:

Previous
From: Vitalii Tymchyshyn
Date:
Subject: Re: Millions of tables
Next
From: Greg Spiegelberg
Date:
Subject: Re: Millions of tables