Big instances admins: if you have CPU issues with psql, I think I know how to lower its usage. With the advice of @krysztophe I added an index on the preview_card table here and my CPU consumption is now back to the floor! I just open an issue and a pr with the hope to have this included for everyone on the next release.
Unix Engineer @nimag_networks |Sysadmin @LaToileScoute |webmaster @ScoutRoseliere
Instance officielle du Parti Pirate Français. CW : Contenus éminemment politiques. / French Pirate Party official server. CW : Firstly Political Contents.