Performance Improvement in SQL - Mailing list pgsql-bugs

From Lucas Souza Cruz
Subject Performance Improvement in SQL
Date
Msg-id CAG84nv9yQrSeOm7Ua63BVu7tGUEj0O_Bya9v+v=YDWtLcQG3WA@mail.gmail.com
Whole thread Raw
Responses Re: Performance Improvement in SQL
List pgsql-bugs
Hi, my name is Lucas Souza and i live in Goi=C3=A2nia, Brazil.
Recently, i had a problem with an SQL due to delay.

The part of the SQL that was slow is: ' WHERE idprod =3D 123456 '.

In this line, the execution was of fifteen seconds.

And i try this: ' WHERE CASE WHEN idprod =3D 123456 THEN TRUE ELSE FALSE EN=
D
=3D TRUE '.

Now, the execution was half of one second.


I sending this e-mail because i believe that the PostgreSQL Community can
improvement the perfomance of database

If this solution exists, sorry for this e-mail.

And sorry too for my english.

Thanks.
Lucas de Souza Cruz

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #14012: How to change password in postgreSQL?
Next
From: Dmitriy Sarafannikov
Date:
Subject: Too many files in pg_replslot folder