Re: Slow timestamp query after upgrading from Pg13 to Pg16

2025-04-07 Thread Simon Windsor
#x27;2025-03-28 01:00'::timestamp); takes 2-3s with the old Pg13 DB, and over a minute with Pg16 After spending many hours looking at DB settings and Statistic settings I am at a loss/ Simon On 07/04/2025 15:51, Laurenz Albe wrote: On Mon, 2025-04-07 at 15:48 +0100, Simon Windsor wrote: Afte

Slow timestamp query after upgrading from Pg13 to Pg16

2025-04-07 Thread Simon Windsor
also appear to be slow. Any ideas, observations or comments would be appreciated Simon -- Simon Windsor Eml:simon.wind...@cornfield.me.uk Mob: 0755 197 9733 “There is nothing in the world that some man cannot make a little worse and sell a little cheaper, and he who considers price only is that

Database upgrade Pg11 to Pg12 issues

2021-02-03 Thread Simon Windsor
se with hard linked files in 11/main and 12/main? In theory it shouldn't and files from 11/main and 12/main will all be under 12/main, I just have doubts. Is there an easy way to tidy this up? Simon -- Simon Windsor Eml: simon.wind...@cornfield.me.uk “There is nothing in the world th

Re: Error XX000 After pg11 upgrade

2019-08-16 Thread Simon Windsor
On Fri, 16 Aug 2019 at 01:28, Tom Lane wrote: > Simon Windsor writes: > > Since then, large bulk inserts of configuration changes are failing with > > this Error, but adhoc and small changes are working ok. > > Might it be that things work as long as the trigge

Re: Error XX000 After pg11 upgrade

2019-08-15 Thread Simon Windsor
ou can see, the id and timestamp are set on insert, and are used to determine the partition used. This issue started after the upgrade to pg11, pg10 and pg9 had no problems. Any ideas would be appreciated. Simon On 15/08/2019 16:31, Tom Lane wrote: Simon Windsor writes: I have just upgraded a

Error XX000 After pg11 upgrade

2019-08-15 Thread Simon Windsor
y ideas or suggestions would be appreciated. Simon -- Simon Simon Windsor Eml: simon.wind...@cornfield.org.uk Tel: 01454 617689 Mob: 07960 321599

Postgres 10 and auto vacuum

2019-03-14 Thread Simon Windsor
appreciated Simon Simon Windsor Eml: simon.wind...@cornfield.org.uk <mailto:simon.wind...@cornfield.org.uk> “There is nothing in the world that some man cannot make a little worse and sell a little cheaper, and he who considers price only is that man's lawful prey.”