Re: Performance difference in accessing differrent columns in a Postgres Table

From: Andres Freund <andres(at)anarazel(dot)de>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>, Dinesh Kumar <dns98944(at)gmail(dot)com>, postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Performance difference in accessing differrent columns in a Postgres Table
Date: 2018-07-30 19:02:24
Message-ID: 20180730190224.6akc4t4blyvjbvwb@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

On 2018-07-30 13:31:33 -0400, Jeff Janes wrote:
> I don't know where the time is going with the as-committed JIT. None of
> the JIT-specific timings reported by EXPLAIN (ANALYZE) add up to anything
> close to the slow-down I'm seeing. Shouldn't compiling and optimization
> time show up there?

As my timings showed, I don't see the slowdown you're reporting. Could
you post a few EXPLAIN ANALYZEs?

Greetings,

Andres Freund

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Janes 2018-07-31 16:56:26 Re: Performance difference in accessing differrent columns in a Postgres Table
Previous Message Andres Freund 2018-07-30 17:45:32 Re: Performance difference in accessing differrent columns in a Postgres Table