Re: [GENERAL] VM-Ware Backup of VM safe?: snapshots: quiesced and non-quiesced

Thank you for "quiesced vs non-quiesced". I will ask the company providing the VM. Regards, Thomas Güttler Am 21.09.2017 um 03:48 schrieb Michael Paquier: On Wed, Sep 20, 2017 at 5:45 PM, Albe Laurenz wrote: Thomas Güttler wrote: We run a PostgreSQL 9.6 server in a virtual machine. The v

[GENERAL] Partition check constraint is ignored if parameter is passed from SQL function

Hello, When query is executed in function that has language set to "sql" then parameters passed to it are not considered as either externally supplied parameters or constants as far as partitioning goes. It will scan all partitions, despite parameters clearly limiting it to just one. Changing fun