Re: Occasional performance issue after changing table partitions

> On 11/07/2022, at 4:05 PM, Justin Pryzby wrote: > > On Mon, Jul 11, 2022 at 03:21:38PM +1200, Nathan Ward wrote: >>> Note that postgres doesn't automatically analyze parent tables, so you >>> should >>> maybe do that whenever the data changes enough for it to matter. >> >> Hmm. This raises

Re: Occasional performance issue after changing table partitions

On Mon, Jul 11, 2022 at 03:21:38PM +1200, Nathan Ward wrote: > > Note that postgres doesn't automatically analyze parent tables, so you > > should > > maybe do that whenever the data changes enough for it to matter. > > Hmm. This raises some stuff I’m not familiar with - does analysing a parent

Re: Occasional performance issue after changing table partitions

> On 11/07/2022, at 2:05 AM, Justin Pryzby wrote: > > On Sun, Jul 10, 2022 at 04:55:34PM +1200, Nathan Ward wrote: >> I am running Postgres 13 on CentOS 7, installed from the yum.postgresql.org >> repo. > > It doesn't sound relevant, but what kind of storage syste

Re: Occasional performance issue after changing table partitions

On Sun, Jul 10, 2022 at 04:55:34PM +1200, Nathan Ward wrote: > I am running Postgres 13 on CentOS 7, installed from the yum.postgresql.org > repo. It doesn't sound relevant, but what kind of storage systems is postgres using ? Filesystem, raid, device. Is the high CP