Re: Very slow Query compared to Oracle / SQL - Server

- 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 = 4000 or entrytype = 4001 or > entrytype = 4002

Order of execution

Hi! My question is: is it possible to optimize function order execution? Here's explanation: I have a bunch of queries that have volatile quals, some more than one. For example: SELECT * FROM clients WHERE some_func(client_id) AND some_other_func(client_id) Now, I know that having vola

Re: Performance issue when we use policies for Row Level Security along with functions

De: "Gopisetty, Ramesh" Para: "pgsql-performance" Enviadas: Quarta-feira, 16 de setembro de 2020 0:39:08 Assunto: Performance issue when we use policies for Row Level Security along with functions BQ_BEGIN Hi, I'm seeing a strange behavior when we implement policies (for RLS - Row

Re: Postgresql server gets stuck at low load

De: "Krzysztof Olszewski" Para: pgsql-performance@lists.postgresql.org Enviadas: Sexta-feira, 5 de junho de 2020 7:07:02 Assunto: Postgresql server gets stuck at low load BQ_BEGIN I have problem with one of my Postgres production server. Server works fine almost always, but sometime

Random function

Hi, I am trying to generate some random data using the random() function. However, I am getting the same result over mulitiple rows. This is a sample of the SQL I am using: select (select string_agg(random()::text,';')           from pg_catalog.generate_series(1,3,1) )   from generate_series(