(TIL) PSQL: Use unlogged tables for caches
Using a Postgres table for caching? You might want to try making it unlogged.
Recent Posts
(TIL) PSQL: Types By Category
Postgres has many types, each of which fall into a particular category. These categories include Array, Boolean, String, Numeric, Composite, etc. Each of the...
(TIL) PSQL: Truncate Tables With Dependents
If you have tables A and B where B has a foreign key referencing A, then trying to truncate A will result in something like this:
(TIL) PSQL: Truncate All Rows
Given a postgres database, if you want to delete all rows in a table, you can use the DELETE query without any conditions.
(TIL) PSQL: Turn Timing On
When digging around your database and running queries, it is helpful to have an eye on the speed of those queries. This can give insight into where there are...