Re: Millions of tables

From: Vitalii Tymchyshyn <vit(at)tym(dot)im>
To: Greg Spiegelberg <gspiegelberg(at)gmail(dot)com>, Craig James <cjames(at)emolecules(dot)com>
Cc: "pgsql-performa(dot)" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Millions of tables
Date: 2016-09-28 15:39:44
Message-ID: CABWW-d1aSpfvPdEaECkt6zoj9faKQx2yndN_TGtQda4HCV1URQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>
> 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.

>
>>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Albright 2016-09-28 16:05:19 Re: Millions of tables
Previous Message Tom Lane 2016-09-28 13:04:52 Re: Unexpected expensive index scan