Postgres Pro
Downloads
Home   >   mailing lists

Re: Millions of tables - Mailing list pgsql-performance

From Vitalii Tymchyshyn
Subject Re: Millions of tables
Date
Msg-id CABWW-d1aSpfvPdEaECkt6zoj9faKQx2yndN_TGtQda4HCV1URQ@mail.gmail.com
Whole thread Raw
In response to Re: Millions of tables  (Greg Spiegelberg <gspiegelberg@gmail.com>)
Responses Re: Millions of tables
Re: Millions of tables
List pgsql-performance
Tree view
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: Tom Lane
Date:
Subject: Re: Unexpected expensive index scan
Next
From: Richard Albright
Date:
Subject: Re: Millions of tables