From: | John R Pierce <pierce(at)hogranch(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: multiple databases vs multiple clusters on the same host |
Date: | 2013-09-28 18:34:23 |
Message-ID: | 5247212F.9050602@hogranch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 9/28/2013 11:29 AM, Tomas Vondra wrote:
> There are probably some corner cases where this might improve the
> performance, but in most cases it's going to be worse. Why are you
> switching to multiple clusters?
>
> For example consider that you'll probably have to use much smaller shared
> buffers (which might cause issues on the active database, while the other
> databases don't use their portion of memory), you'll have to either use
> much smaller max_connections or decrease work_mem (you can't just keep the
> values because then you might run into OOM much more frequently) etc.
indeed, 10 separate checkpoint processes going off asynchronously, meh.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2013-09-28 18:54:27 | Re: PostgreSQL 9.2.4 temp files never released? |
Previous Message | Henrik | 2013-09-28 18:31:04 | recovery from incomplete backup (pgsql 8.3) |