0

Looking for someone well versed in the dark arts of PostgreSQL for some potential consultancy (or anyone that can offer hints, tips and advise).

We have always worked with MySQL and made some naïve assumptions that we would be able to migrate across to PostgreSQL at client's behest but hitting huge page load and performance issues, whether that is with managed database (Digital Ocean) or locally.

Client had advised PosgreSQL but they and us are drawing blanks why the TTFB is so slow both front- and back-end. Even throwing more memory at the managed database isn't really helping (currently 8 GB RAM / 4vCPU / 115 GB Disk).

To note following:

  • Craft Pro 4.3.5 (multisite)
  • PHP 8.1.13
  • PostgreSQL 14.6

Following plugins in place:

  • Amazon S3
  • Blitz
  • Embedded Assets
  • Feed Me
  • Formie
  • Imager X
  • Navigation
  • Neo
  • Redactor
  • SEOmatic
  • Site Switcher
  • Sprig
  • Typed link field
  • Vite

Cole

6
  • What exactly is the question? Employment posts are not permitted, so if you’re just looking to hire someone, this post will be deleted.
    – Lindsey D
    Commented Dec 20, 2022 at 15:59
  • Sorry Lindsey - lemme rephrase. We are having huge performance issues with a Craft 4 site running on PostgreSQL (admittedly our first using this DB engine). Wondering firstly if anyone has any experience or advise on running Craft with PostgreSQL as there is little out there in terms of hints and tips (except some comments/similar experiences on Discord). Failing that "HELP!" as we have a brand new site we are preparing to launch and currently despite using a maxed out DB server the site runs like a one-legged diplodocus in a swimming pool full of honey. Commented Dec 20, 2022 at 16:21
  • No worries. Can you hone in on a specific question? Asking for general performance tips is still incredibly broad and risks being closed for that reason.
    – Lindsey D
    Commented Dec 20, 2022 at 19:08
  • FWIW, you may find Discord to be a better forum for broad, advice-based questions like this one.
    – Lindsey D
    Commented Dec 20, 2022 at 19:09
  • Thanks @LindseyD and totally understand. Sadly it is difficult for us to provide more specifics as everything is running so slowly! Am asking on Devops but wanted to also ask here as Stack Exchange remains (for me at least) the best place to find answers on Craft-based issues so perhaps if something obvious or consistent (eg not project specific) then might help somebody else in the future! Commented Dec 21, 2022 at 10:31

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.