Re: Table scan on 15.2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Arthur Ramsey <arthur(dot)ramsey(at)code42(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Table scan on 15.2
Date: 2023-03-15 16:03:22
Message-ID: 3337979.1678896202@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Arthur Ramsey <arthur(dot)ramsey(at)code42(dot)com> writes:
> I've upgraded from 12.11 to 15.2 and I'm seeing this query now use a
> sequential scan which is taking 500ms instead of < 2ms. If I disable
> sequential scans then it performs as well as 12.11.

What does the EXPLAIN look like with seqscans disabled?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Arthur Ramsey 2023-03-15 16:10:59 Re: Table scan on 15.2
Previous Message Raivo Rebane 2023-03-15 16:02:09 How to behive if I remove password from postgres role