Is an option partitioning the table by month? If your report is month
based, you can improve performance by partitioning.
Felipph
Em dom., 16 de abr. de 2023 às 19:10, Andres Freund
escreveu:
> Hi,
>
> On 2023-04-16 19:00:33 +0200, Clemens Eisserer wrote:
> > I am currently trying to migrate a
m aware of subtransaction problem but I think
this is not the case right now (we had, removed multiple points, some other
points we delivered to God's hands(joking), but know I don't see this issue)
Felipph
Em seg., 7 de mar. de 2022 às 15:07, Tomas Vondra <
tomas.von...@ente
Greatings Ranieri,
Server logs I need ask to someone to get it
Redhat EL 7
Postgres 12
Humm.. I will find out were I should put keep Alive setting
Em seg., 7 de mar. de 2022 13:51, Ranier Vilela
escreveu:
> Em seg., 7 de mar. de 2022 às 08:54, Luiz Felipph
> escreveu:
>
>&g
Hi everybody!
I have a big application running on premise. One of my main database
servers has the following configuration:
72 CPUs(2 chips, 18 physical cores per chip, 2 threads) Xeon Gold 6240
1TB of ram or 786GB (5 servers at all)
A huge storage( I don't know for sure what kind is, but is very
