# Endlessly running Postgres processes & bad performance after Reinstall/restore

**URL:** <https://meta.discourse.org/t/endlessly-running-postgres-processes-bad-performance-after-reinstall-restore/352681>\
**Category:** Support\
**Tags:** postgres\
**Created:** [February 17, 2025, 9:48am UTC](https://meta.discourse.org/t/endlessly-running-postgres-processes-bad-performance-after-reinstall-restore/352681 "2025-02-17T09:48:08Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![helmi](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/helmi/32/114772_2.png) [@helmi](https://meta.discourse.org/u/helmi)\
**Post date:** [February 17, 2025, 9:48am UTC](https://meta.discourse.org/t/endlessly-running-postgres-processes-bad-performance-after-reinstall-restore/352681/1 "2025-02-17T09:48:08Z")

</div>

In an effort to update our Forum I did a fresh VPS install + Restore on the weekend.

This was going to solve multiple issues for us:

- Renew outdated ubuntu
- Update Discourse
- Upgrade to [Postgres 15](https://meta.discourse.org/t/postgresql-15-update/349515)

While generally things went fine I saw issues coming up afterwards with Postgres processes going wild using 100% of a core. Varying numbers of processes though. I tried a few things from a rebuild to restarts. Currently trying a rake db:validate\_indexes which is already running for a few hours without any feedback. I’m not sure if I had done this before and if it’s supposed to happen quicker.

Using the forum works well basically but definitely slowed down. Some longer running tasks like pulling up user profiles from more active users takes notably longer than usual.

I’m quite sure there are some issues with the database but I’m having a hard time finding out which ones.

I gotta say our database is quite huge - we’re at around 150gb after the restore and after index creation. From monitoring the restore process I have not seen any errors and index creation went fine to my eyes.

 ![Screenshot 2025-02-17 @ 10.46.20@2x](https://global.discourse-cdn.com/meta/original/4X/b/f/9/bf9c000549a1899406b4ed31b4b9a26c6ce7a73e.jpeg)

Any idea on how to tackle this? It’s 3 postgress processes right now - it’s been 6 before a restart that I did a few hours ago - I’ve already seen all 16 cores being used after the restore as well.

EDIT: I just noticed right now that 3 sidekiq processes are buys with “indexing categories for search”. May this all just be search index rebuilding? If so can this be solved otherwise? When we do the live system restore, this will be a huge problem if it degrades performance like that over multiple hours or even days.

---

_[View the full topic](https://meta.discourse.org/t/endlessly-running-postgres-processes-bad-performance-after-reinstall-restore/352681)._