work_mem, and machine CPU is below 80% all the time.
Regards,
Mladen Marinović
After a couple of hours of trying different stuff, set enable_mergejoin =
off made the planning time look better: Planning time: 0.322 ms
Any ideas why this helps?
Regards,
Mladen Marinović
On Fri, Dec 6, 2019 at 11:14 AM Mladen Marinović
wrote:
> Hi,
>
> Since this morning our
Hi,
Does anybody know how much RAM does pg_basebackup use and if it depends on
the size of the database that the backup is being created?
Regards,
Mladen Marinović
level give me any more info about what
caused the connection to close?
Regards,
Mladen Marinović
not sure it
will report the stuff you mention. On the database, the log levels
currently are:
client_min_messages = notice
log_min_messages = warning
log_min_error_statement = error
I assume that I should change the first two to at least debug1 to see
something.
> regards, tom lane
>
Regards,
Mladen Marinović
the generic plan might be the problem, but it
is not. Is there any pgBouncer or PG17 parameter that might be the cause of
this?
Regards,
Mladen Marinović
in
different plans when using this tainted pgbouncer connection instead of the
clean one from pg17.
The problem is that server_reset_query is not used when the pool is in
transaction mode. Now, we have to see how to fix this problem.
Regards,
Mladen Marinović
On Mon, May 5, 2025 at 3:10 PM
On Mon, May 5, 2025 at 12:07 PM Achilleas Mantzios <
a.mantz...@cloud.gatewaynet.com> wrote:
>
> On 5/5/25 11:00, Mladen Marinović wrote:
>
>
>
> On Mon, May 5, 2025 at 11:24 AM Achilleas Mantzios <
> a.mantz...@cloud.gatewaynet.com> wrote:
>
>>
On Mon, May 5, 2025 at 2:36 PM Achilleas Mantzios <
a.mantz...@cloud.gatewaynet.com> wrote:
>
> On 5/5/25 13:27, Mladen Marinović wrote:
>
>
>
> On Mon, May 5, 2025 at 12:07 PM Achilleas Mantzios <
> a.mantz...@cloud.gatewaynet.com> wrote:
>
>>
tatistics.
> --
> *From:* Mladen Marinović
> *Sent:* Monday, May 5, 2025 12:27 PM
> *To:* Achilleas Mantzios
> *Cc:* pgsql-general@lists.postgresql.org <
> pgsql-general@lists.postgresql.org>
> *Subject:* Re: Different execution plans in PG17 and pgBouncer...
>
10 matches
Mail list logo
