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 (3 years, 7 months ago)

Latest email

2020-09-29 01:26:58 (3 years, 7 months ago)

Status

2020-11: Committed

Target version

Authors

Tom Lane (tgl), Peter Smith (smithpb2250)

Reviewers

Committer

Tom Lane (tgl)

Links

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