Home > mailing lists

Re: small database huge planning time - Mailing list pgsql-performance

From	Greg Sabino Mullane
Subject	Re: small database huge planning time
Date	January 13 17:44:49
Msg-id	CAKAnmmLSGFSZzyneC-u==0t0ue3GoqkyecbbcJJqTh5tNMmQ2Q@mail.gmail.com Whole thread Raw
In response to	small database huge planning time (Alexander Kulikov <a-kulikov@hotmail.com>)
List	pgsql-performance

On Tue, Jan 13, 2026 at 4:16 AM Alexander Kulikov <a-kulikov@hotmail.com> wrote:

I have got huge planning time for a query in quite small database in PortgreSQL 17  Planning Time: 452.796 ms

> shared_preload_libraries = 'online_analyze, plantuner, pg_stat_statements'

Maybe try without that 'plantuner' extension?

2. querry itself in query.sql.

A smaller and cleaner test query would make it much easier to get help, FYI.

Cheers,

Greg

Enterprise Postgres Software Products & Tech Support

From: Andrei Lepikhov
Date: 13 January, 12:29:45
Subject: Re: small database huge planning time

From: Huanbing Lu
Date: 13 January, 19:07:33
Subject: Re: small database huge planning time