Avoiding stored procedure calls in PostgreSQL that are not necessary
- 22 December 2022
- Database Performance ManagementMachine learning
Almost any common language, like Perl, Python, or C, can be used to write stored procedures in PostgreSQL. Overall, this provides excellent flexibilit…
GAINS AND PITFALLS ARE AMONG THE NEW SEQUENCE FEATURES.
- 21 December 2022
- Deep learningMachine learning
Artificial numeric primary key columns for tables are created using sequences.
Even if more than one database session is using the sequence at the sam…
AVOID “OR” FOR BETTER QUERY PERFORMANCE.
- 19 December 2022
- Machine learningTechnology Business
Of course, there is a need for the OR operator in SQL, so if you can’t avoid it, use it. But you should be mindful of the effects on performance.
I’l…
Postgresql’s Update and AutoVac: A Beginner’s Guide
- 18 December 2022
- Machine learningTechnology Business
It’s surprising how many of the recent PostgreSQL support requests we’ve gotten are about autovacuum and UPDATE in particular. PostgreSQL handles upda…
SLOW QUERIES DETECTED BY POSTGRESQL IN 3 WAYS
- 17 December 2022
- Machine learningTechnology Business
When looking into PostgreSQL performance, it’s important to know how to spot problems and figure out what the server is really doing. So this post is …
The views expressed on this blog are those of the author and do not necessarily reflect the opinions of Enteros Inc. This blog may contain links to the content of third-party sites. By providing such links, Enteros Inc. does not adopt, guarantee, approve, or endorse the information, views, or products available on such sites.
Are you interested in writing for Enteros’ Blog? Please send us a pitch!