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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Performance difference in accessing differrent columns in a Postgres Table
From: Andres Freund <andres@xxxxxxxxxxx>
Date: Mon, 30 Jul 2018 12:02:24 -0700
Cc: Pavel Stehule <pavel.stehule@xxxxxxxxx>, Tom Lane <tgl@xxxxxxxxxxxxx>, David Rowley <david.rowley@xxxxxxxxxxxxxxx>, Dinesh Kumar <dns98944@xxxxxxxxx>, postgres performance list <pgsql-performance@xxxxxxxxxxxxxx>
In-reply-to: <CAMkU=1wYRDLTH7LccR+u2Bj8F4nEYoXdd4z72fLeejFXTcGVNA@mail.gmail.com>
References: <CAEe=mRnNNL3RDKJDmY=_mpcpAb5ugYL9NcchELa6Qgtoz2NjCw@mail.gmail.com> <CAKJS1f_CrjvGYExtmzYzzUnD9XzcbFpo6R_FON2hewSHpqM1xg@mail.gmail.com> <16506.1532905259@sss.pgh.pa.us> <CAFj8pRC-vGCx6NiAO8uUakv00KDv=hPDd5zueFPf5RJe-Uzr+g@mail.gmail.com> <CAMkU=1zVhQ5k5d=YyHNyrigLUNTkOj4=YB17s9--3ts8H-SO=Q@mail.gmail.com> <CAFj8pRBjFfZqF7CuC6PSpqG4u6OD66Kb65UG4je_pJS7TZPTyA@mail.gmail.com> <CAMkU=1wYRDLTH7LccR+u2Bj8F4nEYoXdd4z72fLeejFXTcGVNA@mail.gmail.com>

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

Follow-Ups:
- Re: Performance difference in accessing differrent columns in a Postgres Table
  - From: Jeff Janes

References:
- Performance difference in accessing differrent columns in a Postgres Table
  - From: Dinesh Kumar
- Re: Performance difference in accessing differrent columns in a Postgres Table
  - From: David Rowley
- Re: Performance difference in accessing differrent columns in a Postgres Table
  - From: Tom Lane
- Re: Performance difference in accessing differrent columns in a Postgres Table
  - From: Pavel Stehule
- Re: Performance difference in accessing differrent columns in a Postgres Table
  - From: Jeff Janes
- Re: Performance difference in accessing differrent columns in a Postgres Table
  - From: Pavel Stehule
- Re: Performance difference in accessing differrent columns in a Postgres Table
  - From: Jeff Janes

Prev by Date: Re: Performance difference in accessing differrent columns in a Postgres Table
Next by Date: Re: Performance difference in accessing differrent columns in a Postgres Table
Previous by thread: Re: Performance difference in accessing differrent columns in a Postgres Table
Next by thread: Re: Performance difference in accessing differrent columns in a Postgres Table
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]