Re: Weird seqscan node plan

> > Try increasing the following parameters to 14 (or even 16, if you are not > sure about number of tables involved): > > geqo_threshold = 14 > > from_collapse_limit = 14 > > join_collapse_limit = 14 > > “about 12” is too close to default limit, 12. > > Regards, > > Igor Neyman Hi Igor, Is "

Re: PostGreSQL Replication and question on maintenance

Thanks Jeff for your reply. We are not using replication concept here but doing the data copy using few custom sql scripts. We had our PostgreSQL engine supported by AWS and the instance was restarted automatically based on the AWS design of PostgreSQL engine. Replica is restarted automatically wh

Re: Postgres Full Text Search Jsonb Array column does not search for first row

On Tue, 2019-11-26 at 13:37 +0200, Dmytro Zhluktenko wrote: > Pgsql is unable to perform indexed full text search onto jsonb column > containing an array when looking for the first row in the table. > > Any ideas why this is happening? > > CREATE OR REPLACE FUNCTION cp.make_tsvector(in_t cp."Re

Re: I think that my data is saved correctly, but when printing again, other data appears

I understand. Thank you very much for clearing things up. It helps me a lot, especially point 3. "3. When you run SPI_connect () the memory context is switched transparently for you to a special SPI memory context. When you run SPI_finish () the original memory context (the one in effect be

Re: I think that my data is saved correctly, but when printing again, other data appears

On 11/25/19 4:38 PM, Yessica Brinkmann wrote: > Well, as I was told that I should save the > CurrentMemoryContext before starting the SPI, Let's say it would be > before doing SPI_connect (). Is this correct? And then I must use > MemoryContextStrdup. As you told me the MemoryContextStrdup It is >

RE: Weird seqscan node plan

From: Игорь Выскорко [mailto:vyskorko.i...@yandex.ru] Sent: Tuesday, November 26, 2019 4:13 AM To: Andrei Zhidenkov Cc: pgsql-general@lists.postgresql.org Subject: Re: Weird seqscan node plan 26.11.2019, 16:02, "Andrei Zhidenkov" mailto:andrei.zhiden...@n26.com>>: How many tables do you have in

Postgres Full Text Search Jsonb Array column does not search for first row

Hey, Pgsql is unable to perform indexed full text search onto jsonb column containing an array when looking for the first row in the table.Any ideas why this is happening?Table is nothing more than just Id and Foo which is jsonb column.The case is that I have an empty database with predefined gin i

pgmodeler an server V12

Looks like pgmodeler still requires use of the Beta version to work with a V11 server. I am planing on moving to V12 in the near future. Will this same Beta version work with V12? -- "They that would give up essential liberty for temporary safety deserve neither liberty nor safety."

Re: Weird seqscan node plan

  26.11.2019, 16:02, "Andrei Zhidenkov" :How many tables do you have in your query? If too many, in your case “Genetic Query Optiomiation” might be used (https://www.postgresql.org/docs/10/geqo-pg-intro.html). On 26. Nov 2019, at 03:19, Игорь Выскорко wrote: Hi all!I'm con

Re: Weird seqscan node plan

How many tables do you have in your query? If too many, in your case “Genetic Query Optiomiation” might be used (https://www.postgresql.org/docs/10/geqo-pg-intro.html ). > On 26. Nov 2019, at 03:19, Игорь Выскорко wrote: > > Hi all! > I'm