| From: | Stephen Frost <sfrost(at)snowman(dot)net> |
|---|---|
| To: | Charles <peacech(at)gmail(dot)com> |
| Cc: | David Rowley <dgrowleyml(at)gmail(dot)com>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Query run in 27s with 15.2 vs 37ms with 14.6 |
| Date: | 2023-02-21 16:35:54 |
| Message-ID: | Y/Ty6roAf76C6Pzw@tamriel.snowman.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Greetings,
* Charles (peacech(at)gmail(dot)com) wrote:
> Thank you for the hint. I think this is it. random_page_cost was set to 1.1
> in 14.6 (the data directory is located in a ssd). When upgrading to 15.2 I
> thought that ssd random seek time is not that close to sequential seek
> time, so I revert it back to 4.
In the future, you might want to be sure and include 'settings' in your
EXPLAIN options, eg:
EXPLAIN (ANALYZE, BUFFERS, SETTINGS) query ...
so that you see what non-default planner settings are set when the query
is being planned.
Thanks,
Stephen
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dean Rasheed | 2023-02-21 17:15:39 | Re: BUG #17803: Rule "ALSO INSERT ... SELECT ..." fails to substitute default values |
| Previous Message | Tom Lane | 2023-02-21 15:05:50 | Re: BUG #17803: Rule "ALSO INSERT ... SELECT ..." fails to substitute default values |