Re: Automatic aggressive vacuum on almost frozen table takes too long

On Thu, Feb 16, 2023 at 5:40 PM Mikhail Balayan wrote: >> >> Do you have any non-btree indexes on the table? Can you show us the >> >> details of the >> >> table, including all of its indexes? In other words, can you show "\d >> >> applications" output from psql? > > Only btree indexes. Please

Re: Query plan for "id IS NULL" on PK

Thank you all for your responses! I will continue to put pressure on the vendor (Stitch Data, if anyone knows folks there) to address the issue on their end with the query being issued. Best, Ben Chrobot On Tue, Feb 14, 2023 at 11:11 PM Tom Lane wrote: > David Rowley writes: > > On Wed, 15

Re: Postgres undeterministically uses a bad plan, how to convince it otherwise?

If I may.. this answer looks more "philosophical" than "practical". On Oracle (maybe 10, I don't remember well) was introduced the possibility to explicitly store an execution plan, so that a given query use THAT plan ie. dont go thru planner job. OK if someone do stupid things, one may get stupid

Re: Postgres undeterministically uses a bad plan, how to convince it otherwise?

On 16/02/2023 17:07, David G. Johnston wrote: No, the planner may not cause execution.  While I could imagine extending EXPLAIN to somehow retrieve and maybe even try alternative plans that have been fully constructed today I'm not holding my breath. There is little reason for the project

Sv: PostgreSQL configuration in a VM

På fredag 17. februar 2023 kl. 09:13:10, skrev Sebastien Flaesch < sebastien.flae...@4js.com >: Hi! I was wondering if the is any specific configuration setting that should be used with PostgreSQL, when running in a VM... Is there anything obvious that must

PostgreSQL configuration in a VM

Hi! I was wondering if the is any specific configuration setting that should be used with PostgreSQL, when running in a VM... Is there anything obvious that must be set, to get best performances with such a config? Sorry for this general question... Seb