The Mastodon database includes many PostgreSQL indexes. Indexes aim to make the database more responsive when performing queries against large data sets. There is a particularity with the way PostgreSQL indexes work. They do not release disk space once some data is deleted from a table. For example, let’s say you have a PostgreSQL database with 1000 records and a … Read More
Why is the database size smaller in backups?
Most databases need indexes. Indexes aim to make the database more responsive when performing queries against large data sets. In the case of the Mastodon database, many indexes are necessary to make Mastodon faster to retrieve data. The more indexes one creates, the more disk space is needed, even if the data on the database is the same. When generating … Read More
Mastodon PgBouncer Guide
I did some changes to the initial commit by Nolan to the documentation of Mastodon PgBouncer Guide. As my pull request is still waiting to be approved, I leave it also here because I had some trouble to get it to work with the instructions that were initially shared. Installing PgBouncer On Ubuntu/Debian: sudo apt install pgbouncer Then: nano /etc/default/pgbouncer … Read More