To other Mastodon sysadmins: Check what pg_repack can...

To other Mastodon sysadmins: Check what pg_repack can do for you, especially if your server has been around for a really long time. PostgreSQL indexes get bloated over time and VACUUM does nothing about it. pg_repack can re-build indexes without downtime.

Like 1 Jan 2020 at 4:22 | Open on mastodon.social

1 comment

Feliz Navidaddy

@Gargron will check

1 Jan 2020 at 4:27 | Open on radical.town

Ben Lubar (any pronouns)

@Gargron how does that differ from rebuild index concurrently

1 Jan 2020 at 5:17 | Open on mastodon.lubar.me

Eugen Rochko

I shaved off 40 GB from the mastodon.social database just by using pg_repack on indexes tonight.

1 Jan 2020 at 7:44 | Open on mastodon.social

Baby yoda spice

@Gargron thank you I know what this means

1 Jan 2020 at 7:52 | Open on myasstodon.xyz

erin ｡:ﾟ૮ ˶ˆ ﻌ ˆ˶ ა ﾟ:｡

@Gargron oooooh i should check this

1 Jan 2020 at 7:59 | Open on social.mecanis.me

Rexmortus the Red

@Gargron @aussocialadmin

1 Jan 2020 at 8:01 | Open on aus.social

IVaBCN

@Gargron how I wish I understood what you are saying! How glad I am that you who do use your knowledge to help us have a voice!

1 Jan 2020 at 13:02 | Open on mastodon.social

Bálint Szilakszi

@Gargron postgres 12 has reindex concurrently

1 Jan 2020 at 17:50 | Open on x0r.be

Scott Edwards

@scottedwards200 does this really go back to original post?

4 Jan 2020 at 6:41 | Open on mastodon.social

Jörn Franke

@Gargron Also do not forget to regularly update to the latest Postgres version. The latest (17.0) provides especially for vacuum some interesting improvements: https://www.postgresql.org/docs/17/release-17.html

8 October at 17:53 | Open on mastodon.online

Go Up