Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance difference in accessing differrent columns in aPostgres Table - Mailing list pgsql-performance

From Andres Freund
Subject Re: Performance difference in accessing differrent columns in aPostgres Table
Date
Msg-id 20180730190224.6akc4t4blyvjbvwb@alap3.anarazel.de
Whole thread Raw
In response to Re: Performance difference in accessing differrent columns in aPostgres Table  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: Performance difference in accessing differrent columns in aPostgres Table  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Andres Freund
Date:
Subject: Re: Performance difference in accessing differrent columns in aPostgres Table
Next
From: Jeff Janes
Date:
Subject: Re: Performance difference in accessing differrent columns in aPostgres Table