RE: Help with PostgreSQL Upgrade

2023-09-14 Thread SMITH Matt
Classified as: {OPEN} Hi, Thanks for the messages. It looks like the problem lay in spurious "junk" on the path environment variable. Tidying that up results in pgAdmin being perfectly happy post migration. Matt {OPEN} -Original Message- From: Adrian Klaver Sent: 14 September 2023 1

Re: Help with PostgreSQL Upgrade

2023-09-14 Thread Adrian Klaver
On 9/14/23 03:50, SMITH Matt wrote: Classified as: {OPEN} Hi, We currently have a database hosted in pg 13.1 (with PostGIS 3.1.1) and we are keen to move to pg 15.3 (with PostGIS 3.3.3) all running on Windows 10. I installed pg15 without issue. The pgAdmin 4 utility (bundled with postgres

Re: Access plan selection logic PG9.2 -> PG14

2023-09-14 Thread Adrian Klaver
On 9/14/23 00:15, Ryo Yamaji (Fujitsu) wrote: Hi all I am planning to migrate from PostgreSQL9.2 to PostgreSQL14.7. Running the same SQL with the same statistics as previous versions resulted in different access plans. I have no knowledge of the PostgreSQL planner and would like to be informed

Re: Access plan selection logic PG9.2 -> PG14

2023-09-14 Thread David Rowley
On Fri, 15 Sept 2023 at 01:36, Ryo Yamaji (Fujitsu) wrote: > Question: > I am assuming that the version upgrade has changed the behavior of the > planner. Is this correct? It's possible. 9.2 was a long time ago. It would be quite a bit of work to determine if this is the case. You could perhap

Re: Help with PostgreSQL Upgrade

2023-09-14 Thread Daniel Gustafsson
> On 14 Sep 2023, at 12:50, SMITH Matt wrote: > > Starting the newer pgAdmin results a timeout error on the UI and the > following errors in the pgAdmin log file Are you absolutely sure you are connecting to the right instance with the right connection parameters (hostname, port, TLS settings,

Help with PostgreSQL Upgrade

2023-09-14 Thread SMITH Matt
Classified as: {OPEN} Hi, We currently have a database hosted in pg 13.1 (with PostGIS 3.1.1) and we are keen to move to pg 15.3 (with PostGIS 3.3.3) all running on Windows 10. I installed pg15 without issue. The pgAdmin 4 utility (bundled with postgres 15) connects okay. Then I used the pg_u

Access plan selection logic PG9.2 -> PG14

2023-09-14 Thread Ryo Yamaji (Fujitsu)
Hi all I am planning to migrate from PostgreSQL9.2 to PostgreSQL14.7. Running the same SQL with the same statistics as previous versions resulted in different access plans. I have no knowledge of the PostgreSQL planner and would like to be informed. Please assist. Behavior: I am using an envi