pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Julien Rouhaud <rjuju123@gmail.com>
To: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Cc: 曾文旌(义从) <wenjing.zwj@alibaba-inc.com>
Cc: Pavel Stehule <pavel.stehule@gmail.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Cc: 蔡松露(子嘉) <zijia@taobao.com>
Cc: Cai, Le <le.cai@alibaba-inc.com>
Cc: 萧少聪(铁庵) <shaocong.xsc@alibaba-inc.com>
Subject: Re: [Proposal] Global temporary tables
Date: Mon, 13 Jan 2020 21:12:38 +0100
Message-ID: <20200113201216.GA17684@nol> (raw)
In-Reply-To: <20200113163253.ja34iqsors3o44sv@development>
References: <5767433E-1A77-4682-B3FD-4869911021C8@alibaba-inc.com>
	<6b7570aa-14ea-2f28-c3b5-74dd785bbafe@postgrespro.ru>
	<20200105200603.wrb4beacwb57hhpk@development>
	<33969545-BEF7-4518-A741-302CBF7FF269@alibaba-inc.com>
	<0498c45c-53cb-d9b0-c1e2-7d2d1a618511@postgrespro.ru>
	<20200109164829.mdl3z5xalmaqxs67@development>
	<3fef844f-0e73-8fcb-e4b6-595d6317b191@postgrespro.ru>
	<20200112015109.caab6qdr2ob6d5jv@development>
	<c5f9b7ab-9156-f2f4-d162-99448c3aecfc@postgrespro.ru>
	<20200113163253.ja34iqsors3o44sv@development>

On Mon, Jan 13, 2020 at 05:32:53PM +0100, Tomas Vondra wrote:
> On Mon, Jan 13, 2020 at 11:08:40AM +0300, Konstantin Knizhnik wrote:
> >
> >"if any code tried to access the statistics directly from the table, 
> >rather than via the caches".
> >
> >Currently optimizer is accessing statistic though caches. So this 
> >approach works. If somebody will rewrite optimizer or provide own 
> >custom optimizer in extension which access statistic directly
> >then it we really be a problem. But I wonder why bypassing catalog 
> >cache may be needed.
> >
> 
> I don't know, but it seems extensions like hypopg do it.

AFAIR, hypopg only opens pg_statistic to use its tupledesc when creating
statistics on hypothetical partitions, but it should otherwise never reads or
need plain pg_statistic rows.





view thread (525+ messages)  latest in thread

Message-ID: <20200113201216.GA17684@nol>
Permalink:  ../20200113201216.GA17684@nol/
Also on:    postgresql.org/message-id/20200113201216.GA17684@nol

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: rjuju123@gmail.com, tomas.vondra@2ndquadrant.com, k.knizhnik@postgrespro.ru, wenjing.zwj@alibaba-inc.com, pavel.stehule@gmail.com, robertmhaas@gmail.com, zijia@taobao.com, le.cai@alibaba-inc.com, shaocong.xsc@alibaba-inc.com
  Subject: Re: [Proposal] Global temporary tables
  In-Reply-To: <20200113201216.GA17684@nol>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox