Postgres: How Long does it take to DELETE a large amount of records and VACUUM FULL?
Sometimes there is table bloat on your postgres tables. A large amount of data that is stored that serves no […]
Database, postgres
postgres
postgres
Postgres: Querying Arrays
Quering tables that contain arrays can be tricky in postgres. The Postgres docs: Array functions provide a good explanation but […]
postgres
Postgres: Does Dropping Indexes and Foreign Keys before Inserts Really Work to Speed up Performance?
There is a use case where about 10000 records are inserted every few seconds after some processing. There was a […]
postgres
Postgres and Django Case Sensitivity
Postgres queries are CaSeSensitivE unlike in MySQL. When a simple Model.objects.get(field=’hello’) would get the record. Using a postgres db you […]