| From: | Alexander Kuzmenkov <a(dot)kuzmenkov(at)postgrespro(dot)ru> |
|---|---|
| To: | David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Generating partitioning tuple conversion maps faster |
| Date: | 2018-06-29 12:22:04 |
| Message-ID: | e116f60f-3a2b-0366-adc1-bfc553d9f71c@postgrespro.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | Postg스포츠 토토 결과SQL |
On 06/29/2018 03:25 AM, David Rowley wrote:
> I've attached a patch that uses SearchSysCacheAttName to speed up
> these translations in the planner.
Good idea. On my desktop, this gives 270 tps dropped vs 610 tps plain
(for updates). If you combine it with persistent inner loop index, it's
probably going to be even faster, because it will only require one
catalog access for each index shift. Now it looks like it goes to
catalog for every column after the dropped one.
What about convert_tuples_by_name_map, do you plan to switch it to
catalog lookups as well?
--
Alexander Kuzmenkov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2018-06-29 12:23:13 | Re: Tips on committing |
| Previous Message | Michael Paquier | 2018-06-29 12:19:26 | Re: Tips on committing |