Re: BUG #18599: server closed the connection unexpectedly

Thank you all in helping with this issue.
Regards
________________________________
From: Magnus Hagander <magnus(at)hagander(dot)net>
Sent: Saturday, September 7, 2024 1:22 AM
To: Karim Chaid <kchaid(at)hotmail(dot)com>
Cc: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>; David Rowley <dgrowleyml(at)gmail(dot)com>; PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #18599: server closed the connection unexpectedly

On Sat, Sep 7, 2024, 00:18 Karim Chaid <kchaid(at)hotmail(dot)com<mailto:kchaid(at)hotmail(dot)com>> wrote:
One quick test recommended for me is to convert the columnar tables to heap.
Upon doing it, the query worked. It was hung in the first attempt but in the second attempt worked fine.

I would to get this resolved for columnar setup.

There's no such thing as columnar in PostgreSQL. You must be using either a fork or some pretty complex extension. It seems pretty clear that the problem is in that code and not in PostgreSQL since it goes away when you switch off it. So you're probablh better off reporting it to them.

/Magnus