| From: | Justin Clift <justin(at)postgresql(dot)org> |
|---|---|
| To: | David Rowley <dgrowleyml(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, nikhil raj <nikhilraj474(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, NIKITA PATEL <patelnikita1411(at)gmail(dot)com>, Patel Khushbu <patelkhushbu2067(at)gmail(dot)com> |
| Subject: | Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables. |
| Date: | 2024-08-28 06:58:56 |
| Message-ID: | 7b97171e276c41ec6ae4eeb8c2e8b47d@postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On 2024-08-27 20:14, David Rowley wrote:
> On Tue, 27 Aug 2024 at 18:00, Justin Clift <justin(at)postgresql(dot)org>
> wrote:
>> As a general thought, seeing that this might be an actual problem
>> should some kind of automated testing be added that checks for
>> performance regressions like this?
>
> We normally try to catch these sorts of things with regression tests.
> Of course, that requires having a test that would catch a particular
> problem, which we don't seem to have for this particular case. A
> performance test would also require testing a particular scenario, so
> I don't see why that's better. A regression test is better suited as
> there's no middle ground between pass and fail.
Yeah, that's the kind of thing I was thinking.
Any idea who normally does those, and if it would be reasonable to add
test(s) for the internal information tables?
Regards and best wishes,
Justin Clift
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Guo | 2024-08-28 07:08:16 | Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables. |
| Previous Message | KK CHN | 2024-08-28 05:39:51 | Pgbackrest specifying the default DB necessary/correct way ? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Guo | 2024-08-28 07:08:16 | Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables. |
| Previous Message | Peter Smith | 2024-08-28 06:54:27 | Re: Conflict detection and logging in logical replication |