Coder Social home page Coder Social logo

Comments (4)

kmoppel avatar kmoppel commented on July 24, 2024

This is expected. It's a SIGHUP level setting, i.e. you need to reload config (or restart the server).

localhost:5432 krl@postgres=# select name, context from pg_settings where name ~ 'worker_naptim';
          name          │ context 
────────────────────────┼─────────
 squeeze.worker_naptime │ sighup
(1 row)

from pg_squeeze.

pmpetit avatar pmpetit commented on July 24, 2024

So i change it in postgresql.conf ?
What is GUC parameter ?
GUC stand for ?
Thanks

from pg_squeeze.

pmpetit avatar pmpetit commented on July 24, 2024

According to me, the confusion comes from the readme

add entries like this to postgresql.conf file
squeeze.worker_autostart = 'my_database your_database'
squeeze.worker_role = postgres

and

consider setting "squeeze.max_xlock_time" GUC parameter. For
example

SET squeeze.max_xlock_time TO 100;

so i thought i should use set to change "naptime"

from pg_squeeze.

kmoppel avatar kmoppel commented on July 24, 2024

@pmpetit Yes, max_xlock_time param can be set anytime as it has the "user" context. GUC I think stands for Grand Unified Config but basically just means a config param. But yes this "squeeze.worker_naptime" requires ALTER SYSTEM or config file change + a reload.

from pg_squeeze.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.