Trim performance on 9.5

From: William Ivanski <william(dot)ivanski(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Trim performance on 9.5
Date: 2016-11-18 14:06:36
Message-ID: CACaWZ9SPTAhY9-Uxucs2692V=-uSc7tBiW8V3Qu0bT6GLkDxdQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I recently did major improvements on perfomance on our routines by simply
removing the call for trim functions on specific bottlenecks. Please see
images attached for a simple example.

I'm using PostgreSQL version 9.5.5-1.pgdg80+1 on Debian 8.6. Someone knows
if it's a bug on trim function? Thanks in advance.

--

William Ivanski

Attachment Content-Type Size
image/png 20.5 KB
image/png 22.9 KB
image/png 18.7 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message vinny 2016-11-18 14:16:33 Re: Trim performance on 9.5
Previous Message Kouhei Kaigai 2016-11-18 14:06:05 Re: How the Planner in PGStrom differs from PostgreSQL?