Cache result of timestampt2tm for same transaction timestamp

Title

Topic

Performance

Created

2020-09-28 02:24:06

Last modified

2020-09-28 16:10:30 (4 years, 2 months ago)

Latest email

2020-09-29 01:26:58 (4 years, 2 months ago)

Status

2020-11: Committed

Target version

Authors

Tom Lane (tgl), Peter Smith (smithpb2250)

Reviewers

Committer

Tom Lane (tgl)

Links

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/2746
git checkout commitfest/cf/2746

Emails

Load TIME fields - proposed performance improvement: First at 2020-09-22 01:42:55 by Peter Smith <smithpb2250 at gmail.com>
Latest at 2020-09-29 01:26:58 by Peter Smith <smithpb2250 at gmail.com>
Latest attachment (cache_pg_tm-v02.patch) at 2020-09-25 16:17:05 from Tom Lane <tgl at sss.pgh.pa.us>
    Attachment (cache_pg_tm-v02.patch) at 2020-09-25 16:17:05 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (PS_cache_pg_tm-v01.patch) at 2020-09-25 06:34:03 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (DecodeTimeOnly_GetCurrentDateTime.patch) at 2020-09-22 01:42:55 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)

History

When	Who	What
2020-09-28 16:10:30	Tom Lane (tgl)	Closed in commitfest 2020-11 with status: Committed
2020-09-28 16:10:29	Tom Lane (tgl)	Changed committer to tgl
2020-09-28 02:33:45	Peter Smith (smithpb2250)	Changed authors to Tom Lane (tgl), Peter Smith (smithpb2250)
2020-09-28 02:25:32	Peter Smith (smithpb2250)	Changed authors to Peter Smith (smithpb2250)
2020-09-28 02:24:06	Peter Smith (smithpb2250)	Attached mail thread CAHut+Pu89TWjq530V2gY5O6SWi=OEJMQ_VHMt8bdZB_9JFna5A@mail.gmail.com
2020-09-28 02:24:06	Peter Smith (smithpb2250)	Created patch record