How to use postgresql.conf to configure and tune the PostgreSQL server

Sdílet
Vložit
  • čas přidán 22. 08. 2024

Komentáře • 9

  • @mr.g.fisher
    @mr.g.fisher Před 2 lety

    I'm just starting out on my PostgreSQL journey... this was very useful! Thanks 🙂

  • @drip888
    @drip888 Před 2 lety

    what the guy on the bottom told was right, if tuning was fully automatic and if we want, we can change it ourselves but if we dont, we should have an option to make it fully automatic so it would tune itself according to cirucumstances of the database. if that exist, omg postgres would literally skyrocket. Not everyone is crazy to actually deal with these paramters a lot. It takes a lot of time to do it manually and seeing if its better or not.

    • @hyperking9381
      @hyperking9381 Před rokem

      it can be done by associating with powerful APM tools. Heap memory became biggest issue for every database. if we can clear the unwanted objects and manage heap memory efficiently the process will automatically become automatic. unwanted(useful but not in the process we are using right now) data runs on database hardware veins every time

  • @getrajeev19
    @getrajeev19 Před rokem

    i was expecting description of each and every parameter of postgres.conf file but .. its Simply waste of time ..

  • @hirenbhatt9808
    @hirenbhatt9808 Před 3 lety

    Indian rocks again

  • @hirenbhatt9808
    @hirenbhatt9808 Před 3 lety

    Hiren Bhatt
    1 second ago
    Indian rocks again

  • @hirenbhatt9808
    @hirenbhatt9808 Před 3 lety

    Hiren Bhatt
    1 second ago
    Indian rocks again

  • @hirenbhatt9808
    @hirenbhatt9808 Před 3 lety

    Hiren Bhatt
    1 second ago
    Indian rocks again

  • @hirenbhatt9808
    @hirenbhatt9808 Před 3 lety

    Hiren Bhatt
    1 second ago
    Indian rocks again