RE: Query Tunning related to function

.translate_payment_status(t.payment_sid_c) From ( Select payment_sid_c from lms_app.lms_payment_check_request group by payment_sid_c having lms_app.translate_payment_status(payment_sid_c) IN ('PAID', 'MANUALLYPAID') ) t Regards Michel SA

RE: Optimal configuration for server

Hi, Another point to verify is idle_in_transaction_session_timeout What is the value of this parameter? Regards Michel SALAIS De : Luiz Felipph Envoyé : lundi 7 mars 2022 22:07 À : Tomas Vondra Cc : Pgsql Performance Objet : Re: Optimal configuration for server Hi Tomas

RE: Simple task with partitioning which I can't realize

mns be part of the primary key AND any other UNIQE constraint. Michel SALAIS

RE: PostgreSQL 12.8 Same Query Same Execution Plan Different Time

Michel SALAIS De : David G. Johnston Envoyé : mercredi 19 janvier 2022 16:11 À : Ludwig Isaac Lim Cc : pgsql-performa...@postgresql.org Objet : Re: PostgreSQL 12.8 Same Query Same Execution Plan Different Time On Wed, Jan 19, 2022 at 7:59 AM Ludwig Isaac Lim mailto:ludz_...@yahoo.com

RE: sql execution time in pg_stat_statements

Hi Tom, I was out of this list for a while. Unfortunately, I have now no access to the server where I have seen this. Best regards Michel SALAIS -Message d'origine- De : Tom Lane Envoyé : vendredi 10 septembre 2021 19:42 À : Michel SALAIS Cc : 'Julien Rouhaud&#x

RE: sql execution time in pg_stat_statements

-Message d'origine- De : Julien Rouhaud Envoyé : vendredi 10 septembre 2021 07:18 À : Michel SALAIS Cc : postgres performance list Objet : Re: sql execution time in pg_stat_statements On Fri, Sep 10, 2021 at 2:49 AM Michel SALAIS wrote: > > I think that to

RE: sql execution time in pg_stat_statements

Just to say that for PostgreSQL 13, total_time is replaced by “total_exec_time + total_plan_time” Michel SALAIS De : Michel SALAIS Envoyé : jeudi 9 septembre 2021 20:14 À : pgsql-performa...@postgresql.org Objet : sql execution time in pg_stat_statements Hi all, I think that

sql execution time in pg_stat_statements

Hi all, I think that total_time in pg_stat_statements is cpu time + possible waits. So, can I say that: Total_sql_time = total_time + blk_read_time + blk_write_time Documentation is not clear at all on that. Thanks in advance Michel SALAIS

RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4

Hi, Something which has nothing with the thread but I think it must be said :-) Why substring(x, 0, ...)? msym=> select substr('abcde', 0, 3), substr('abcde', 1, 3); substr | substr + ab | abc Michel SALAIS

RE: Partition column should be part of PK

have to be rebuilt. But, anyway, such operations could be done "concurrently" or "online"... Michel SALAIS -Message d'origine- De : David Rowley Envoyé : lundi 12 juillet 2021 02:57 À : Nagaraj Raj Cc : Christophe Pettus ; pgsql-performa...@postgresql.org Objet :

RE: Partition with check constraint with "like"

ve it when you describe the table… But I think like others have already said that this is perhaps not the right choice. Michel SALAIS De : Nagaraj Raj Envoyé : samedi 22 mai 2021 01:28 À : 'David Rowley' ; Michel SALAIS Cc : 'Justin Pryzby' ; 'Pgsql-perfor

RE: Partition with check constraint with "like"

Hi I don’t discuss here the choice itself but this is not correct: create table mytable_z of mytable for values from ('Z') to ('Z['); It should be create table mytable_z of mytable for values from ('Z') to ('[') Michel SALAIS De : Nagaraj R

RE: different execution time for the same query (and same DB status)

Hi, Have you tried to use EXPLAIN ANALYZE at least? It could give valuable information about why this is occurring. Michel SALAIS De : Francesco De Angelis Envoyé : samedi 6 mars 2021 22:40 À : pgsql-performance@lists.postgresql.org Objet : Fwd: different execution time for the same