IN POSTGRESQL, DO NOT USE ENTITY-ATTRIBUTE-VALUE (EAV) DESIGN!
- 27 November 2022
- Database Performance ManagementTechnology Business
Customer inquiries about my opinion of “Entity-attribute-value” (EAV) design are frequent. I therefore decided that it would be wise to express my vie…
Normalization of data in PostgreSQL
- 26 November 2022
- Database Performance ManagementDeep learning
Introduction
Even though I installed RedHat Linux 6.0 (not RHEL) in 1999 to set up my first PostgreSQL database, I probably only used this 6.5 relea…
Practical Examples of PostgreSQL Data Normalization
- 25 November 2022
- Database Performance ManagementTechnology Business
After completing a theoretical introduction in part 1, it is time to talk about some additional real-world examples. I’ll begin by discussing the……
Data types for query parameters and performance
- 23 November 2022
- Database Performance ManagementTechnology Business
Recently, I was able to assist a customer in resolving a “mysterious” performance issue. The problem was that the type of query parameter wasn’t chose…
Better PostgreSQl performance on slow networks with pipeline mode
It is well known that poor database performance results from high network latency. For the libpq C API, PostgreSQL v14 introduced “pipeline mode,” whi…
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!