Re: pgbouncer

From: Rita <rmorgan466(at)gmail(dot)com>
To: Sebastiaan Mannem <sebas(at)mannem(dot)nl>
Cc: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: pgbouncer
Date: 2023-06-28 14:16:58
Message-ID: CAOF-Kfi5sBbuYwF8F0fa9u-1XAZx6yD_XZYXvDHxxzvmGe_h9w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a dedicated server. I have 3 additional physical application servers
which hit the database. I periodically get the application server not able
to reach the database server (is server on port 5432 listening? message).
Looking at some metrics, seems like I am pulling a lot of tuples (300k or
so) during that time.

On Wed, Jun 28, 2023 at 8:23 AM Sebastiaan Mannem <sebas(at)mannem(dot)nl> wrote:

> It greatly depends on what you want to achieve. Both have pro’s and con’s.
> What do you need pgbouncer for?
>
> Verstuurd vanaf mijn iPhone
>
> > Op 28 jun. 2023 om 13:19 heeft Rita <rmorgan466(at)gmail(dot)com> het volgende
> geschreven:
> >
> > 
> >
> > seems like I may need to deploy pgbouncer for my webapp. should i deploy
> it on the db server or on the webserver?
> > --
> > --- Get your facts first, then you can distort them as you please.--
>

--
--- Get your facts first, then you can distort them as you please.--

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ben Chobot 2023-06-28 14:24:12 Re: typical active table count?
Previous Message Giovanni Biscontini 2023-06-28 12:43:08 Re: pgbouncer