Re: Millions of tables
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Re: Millions of tables
From
: Vitalii Tymchyshyn <vit@xxxxxx>
Date
: Wed, 28 Sep 2016 15:39:44 +0000
Cc
: "pgsql-performa." <pgsql-performance@xxxxxxxxxxxxxx>
In-reply-to
: <
CAEtnbpV49mB19Gq3YG6UnFE9wSBA8bRQBaOjui5nHP2eMpCj4A@mail.gmail.com
>
References
: <
CAEtnbpVXi0ESh16KAeYkFOiFPhTrJ2JXps9PypuAGCYidWtcnA@mail.gmail.com
> <CAFwQ8rdx6Uz4zE7dQ4jvr-oYbx+aamkyBnuURca-voyNUd85=g@mail.gmail.com> <
CAEtnbpV49mB19Gq3YG6UnFE9wSBA8bRQBaOjui5nHP2eMpCj4A@mail.gmail.com
>
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.
Follow-Ups
:
Re: Millions of tables
From:
Greg Spiegelberg
Re: Millions of tables
From:
Richard Albright
References
:
Millions of tables
From:
Greg Spiegelberg
Re: Millions of tables
From:
Craig James
Re: Millions of tables
From:
Greg Spiegelberg
Prev by Date:
Re: Unexpected expensive index scan
Next by Date:
Re: Millions of tables
Previous by thread:
Re: Millions of tables
Next by thread:
Re: Millions of tables
Index(es):
Date
Thread
[Postgresql General]
[Postgresql PHP]
[PHP Users]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Yosemite]