On 09/20/21 15:33, Kirill wrote:
Hello,
As modern software is typically multi-tenant aware it is critical for
DB to effectively filter
database records based on tenant ID context. Yet, we constantly hit
the situations when Postgres 13.4 performs poorly.
If community is interested I can report s
On 05/29/21 07:08, Dean Gibson (DB Administrator) wrote:
On 2021-05-28 19:43, Christophe Pettus wrote:
...
The most common reason for this kind of inexplicable stuff after an RDS upgrade
is, as others have said, parameter changes, since you get a new default
parameter group after the upgrade.
On 05/24/21 19:24, Christophe Pettus wrote:
On May 24, 2021, at 09:22, Bob Jolliffe wrote:
It is hard to say as it only happens for 30s couple of times per day.
Everything does return to normal after the blocking transaction is
committed. It could be a disk thing or even a network issue (the
On 05/06/21 23:02, Alexey M Boltenkov wrote:
On 05/06/21 22:58, Alexey M Boltenkov wrote:
Have you try of excluding not null from index? Can you give
dispersion of archivestatus?
06.05.2021, 21:59, "Semen Yefimenko" :
Yes, rewriting the query with an IN clause was als
On 05/06/21 22:58, Alexey M Boltenkov wrote:
Have you try of excluding not null from index? Can you give dispersion
of archivestatus?
06.05.2021, 21:59, "Semen Yefimenko" :
Yes, rewriting the query with an IN clause was also my first
approach, but I didn't help much
query to be WITHOUT nulls. Thank you already for the hint. What else can I do? With the current parameters, the query finishes in about 3.9-5.2 seconds which is already much better but still nowhere near the speeds of 280 ms in oracle.I would love to get it to at least 1 second. Am Do., 6. M
On 05/06/21 21:15, Alexey M Boltenkov wrote:
On 05/06/21 19:11, luis.robe...@siscobra.com.br wrote:
- Mensagem original -
De: "Semen Yefimenko"
Para: "pgsql-performance"
Enviadas: Quinta-feira, 6 de maio de 2021 11:38:39
Assunto: Very slow Query compared to Oracle /
On 05/06/21 19:11, luis.robe...@siscobra.com.br wrote:
- Mensagem original -
De: "Semen Yefimenko"
Para: "pgsql-performance"
Enviadas: Quinta-feira, 6 de maio de 2021 11:38:39
Assunto: Very slow Query compared to Oracle / SQL - Server
SELECT column1,..., column54 where ((entrytype =
