Re: Performance difference in accessing differrent columns in aPostgres Table

From: Andres Freund
Subject: Re: Performance difference in accessing differrent columns in aPostgres Table
Date: ,
Msg-id: 20180730190224.6akc4t4blyvjbvwb@alap3.anarazel.de
(view: Whole thread, Raw)
In response to: Re: Performance difference in accessing differrent columns in aPostgres Table  (Jeff Janes)
Responses: Re: Performance difference in accessing differrent columns in aPostgres Table  (Jeff Janes)
List: pgsql-performance

Tree view

Performance difference in accessing differrent columns in a Postgres Table  (Dinesh Kumar, )
 Re: Performance difference in accessing differrent columns in aPostgres Table  (David Rowley, )
  Re: Performance difference in accessing differrent columns in a Postgres Table  (Tom Lane, )
   Re: Performance difference in accessing differrent columns in aPostgres Table  (Pavel Stehule, )
    Re: Performance difference in accessing differrent columns in aPostgres Table  (Jeff Janes, )
     Re: Performance difference in accessing differrent columns in aPostgres Table  (Pavel Stehule, )
      Re: Performance difference in accessing differrent columns in aPostgres Table  (Jeff Janes, )
       Re: Performance difference in accessing differrent columns in aPostgres Table  (Andres Freund, )
        Re: Performance difference in accessing differrent columns in aPostgres Table  (Jeff Janes, )
         Re: Performance difference in accessing differrent columns in aPostgres Table  (Dinesh Kumar, )
          Re: Performance difference in accessing differrent columns in aPostgres Table  (Jeff Janes, )
           Re: Performance difference in accessing differrent columns in aPostgres Table  (Jeff Janes, )
            Re: Performance difference in accessing differrent columns in aPostgres Table  (Dinesh Kumar, )
      Re: Performance difference in accessing differrent columns in aPostgres Table  (Andres Freund, )
     Re: Performance difference in accessing differrent columns in aPostgres Table  (Andres Freund, )
      Re: Performance difference in accessing differrent columns in aPostgres Table  (Jeff Janes, )
       Re: Performance difference in accessing differrent columns in aPostgres Table  (Andres Freund, )

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:

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