Month: June 2015
Using temporary tables the way they should not be used
Temporary tables are a core feature of SQL and are commonly used by people around the globe. PostgreSQL provides a nice implementation of temporary tables, which has served me well over the years. An interesting question arises when using a temporary table: What if a temporary table has the same name as a “real” table? What […]
Read more
DROP TABLE: Killing shared_buffers
Tuning shared_buffers in PostgreSQL is a pretty fundamental thing to do when setting up a high-performance server. In most cases adding more memory speeds up things considerably. Many tests have shown exactly that. However, there are some corner cases, which are not commonly mentioned and which can cause significant performance issues in some very rare […]
Read more