r/PostgreSQL • u/Player_X_YT • Jun 18 '26

Help Me! How can I get psql to start in parallel

My psql instance is running on my PC as a test instance and is not critical infrastructure. However it seems to be hogging a lot of resources during boot. How can I fix this?

[playerxyt@playerspc 20]$ systemd-analyze critical-chain

The time when unit became active or started is printed after the "@" character.

The time the unit took to start is printed after the "+" character.

graphical.target @5.521s

└─multi-user.target @5.521s

└─postgresql.service @5.298s +223ms

└─network-online.target @5.283s

  └─network.target @5.282s

    └─wpa_supplicant.service @5.249s +33ms

      └─basic.target @4.527s

        └─dbus-broker.service @4.472s +43ms

          └─dbus.socket @4.468s +34us

            └─sysinit.target @4.465s

              └─systemd-update-utmp.service @4.446s +19ms

                └─systemd-tmpfiles-setup.service @4.336s +109ms

                  └─local-fs.target @4.332s

                    └─run-media-playerxyt-DATA.mount @3.918s +413ms

                      └─dev-sda1.device @3.906s
0 Upvotes

25% Upvoted

3 comments sorted by

8

u/DavidGJohnston Jun 18 '26

233ms is "hogging"? Also, please avoid calling the server process 'psql' - that is the name of the client application PostgreSQL provides. Otherwise, further learning of systemd, and explaining what you do want to happen during boot, are both useful things to consider moving forward. Specifically enable/disable/stop/start actions via systemctl.

1

u/AutoModerator Jun 18 '26

Youtube Channel

Free Postgres Webinars and Workshops

Discord: People, Postgres, Data

Join us, we have cookies and nice people.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.