Tag: database performance
-
Descriptive names for column constraints in Hibernate
by
Hibernate (re-)generates names for database constraints such as foreign keys or unique columns when creating a schema. However, the names for indexes and unique keys are not very descriptive, since they are created from a hash string of the table and column name. Unreadable technical names may seem just to be an insignificant ugliness, but…
-
Postgres Performance Troubleshooting – An Example
by
Recently we encountered some severe performance problems in one of our projects. Some SQL queries were very slow. A certain query took over 6 seconds to finish in Azure’s Postgres service and about 350ms locally on my laptop. Both are unacceptable. I don’t know much more than the postgres basics and the project was in…
-
PostgreSQL: Partitioning big tables (Part 2)
Dieser Artikel auf Deutsch Alongside various strategies for handling large amounts of data with indexes, PostgreSQL provides another feature: splitting the table with inheritance. This separation of a table’s data into different child tables is called “partitioning” in PostgreSQL. In part one, we described the pro and cons of this method and its conditions of…
-
PostgreSQL: Partitioning big tables (Part 1)
Dieser Artikel auf Deutsch Alongside various strategies for handling large amounts of data with indexes, PostgreSQL provides another feature: splitting the table with inheritance. This separation of a table’s data into different child tables is called “partitioning” in PostgreSQL. Because it does require a bit of effort to implement, and because there are also limitations…
You must be logged in to post a comment.