Re: Terribly slow query with very good plan?

Hi Les, I have reviewed the whole thread, and I do not see usage of gist or gin indexes. Have you tried using Gist or GIN indexes instead of a normal b-tree? B-trees are a good option when your search is simple(e.g. =, >, <). The operators you are using are "like" or "^@", which fall into a full-

Re: WAL files keep piling up

A stupid question. How many .ready files are there? Regards, Ninad Shah On Wed, 22 Dec 2021 at 21:04, Zbigniew Kostrzewa wrote: > Hi, > > I have a PostgreSQL (9.6.15) two node cluster setup with Patroni. The > instances are configured to work in master <-> synchronous standb

Re: Query out of memory

Do you see any issue in PostgreSQL log files? Regards, Ninad Shah On Tue, 19 Oct 2021 at 16:17, aditya desai wrote: > Hi Justin, > Out of memory on pgadmin and psql. I executed it with explain analyze. > Still going out of memory. > > Also currently 250 user connections are

Re: Performance benchmark of PG

hould find any performance issues on PostgreSQL. All the best. Regards, Ninad Shah On Mon, 19 Jul 2021 at 16:54, Manish Lad wrote: > Thank you all for your swift response. > > Thank you again. > > Manish > > On Mon, 19 Jul 2021, 15:39 Manish Lad, wrote: > >>