"Jim C. Nasby" <decibel@decibel.org> writes:
> I think it would be useful to have a means to adjust the queue sizes
> dynamically from a database connection. If the optimum queue sizes
> depend on the workload this would allow things like batch processes to
> tweak the queue sizes for better performance when they're running.
That strikes me as a bad idea --- what will cause the queue size to
revert to normal, if the batch process fails before resetting it?
In any case, the only mechanism we have available for such things is
modifying postgresql.conf and then SIGHUPping the postmaster; there is
no other way to adjust a parameter that all backends must see as having
the same value. So even if we invent a GUC parameter for this, it's not
going to be something your batch process can lightly fool around with.
regards, tom lane
