(TIL) PSQL: Use unlogged tables for caches
Using a Postgres table for caching? You might want to try making it unlogged.
Using a Postgres table for caching? You might want to try making it unlogged.
Postgres has many types, each of which fall into a particular category. These categories include Array, Boolean, String, Numeric, Composite, etc. Each of the...
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:
Given a postgres database, if you want to delete all rows in a table, you can use the DELETE query without any conditions.
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...