Re: temporary file log lines

Hi, Le lun. 12 juil. 2021 à 14:13, MichaelDBA a écrit : > hmmm, I think spilling over to disk for temporary tables is handled by > an entirely different branch in the PG source code. In fact, some other > folks have chimed in and said log_temp_files doesn't relate to temp > files at all use by

Re: Understanding bad estimate (related to FKs?)

Hi, Le lun. 2 nov. 2020 à 20:09, Philip Semanchuk a écrit : > > > > On Oct 31, 2020, at 9:53 AM, Guillaume Lelarge > wrote: > > > > Hi, > > > > Le ven. 30 oct. 2020 à 15:57, Philip Semanchuk < > phi...@americanefficient.com> a écrit : > &g

Re: Understanding bad estimate (related to FKs?)

Hi, Le ven. 30 oct. 2020 à 15:57, Philip Semanchuk a écrit : > > > > On Oct 29, 2020, at 6:48 PM, Tomas Vondra > wrote: > > > > On Thu, Oct 29, 2020 at 11:25:48AM -0400, Philip Semanchuk wrote: > >> > >> > >>> On Oct 28, 2020, at 9:13 PM, Justin Pryzby > >>> wrote: > >>> > >>> On Mon, Oct 26,

Re: unexpected result for wastedbytes query after vacuum full

Le mar. 10 déc. 2019 à 20:48, Jeff Janes a écrit : > On Tue, Dec 10, 2019 at 11:43 AM Guillaume Lelarge > wrote: > > This query uses the column statistics to estimate bloat. AFAIK, json >> columns don't have statistics, so the estimation can't be relied on (for >

Re: unexpected result for wastedbytes query after vacuum full

Le ven. 6 déc. 2019 à 18:18, Mike Schanne a écrit : > Hi all, > > > > This question is somewhat related to my previous question: > > > https://www.postgresql.org/message-id/0871fcf35ceb4caa8a2204ca9c38e330%40USEPRDEX1.corp.kns.com > > > > I was attempting to measure the benefit of doing a VACUUM

Re: does dml operations load the blocks to the shared buffers ?

Le jeu. 10 janv. 2019 à 11:40, Mariel Cherkassky < mariel.cherkas...@gmail.com> a écrit : > . Lets assume the amount of data I insert is bigger than the > shared_buffers. I didnt commit the transaction yet, the data will be saved > on temp files until I commit ? > What happens if I have in my tran

Re: does dml operations load the blocks to the shared buffers ?

Le jeu. 10 janv. 2019 à 09:07, Mariel Cherkassky < mariel.cherkas...@gmail.com> a écrit : > Hey, > It is clear that when we query some data, if that data isnt in the shared > buffers pg will go bring the relevant blocks from the disk to the shared > buffers. I wanted to ask if the same logic works

Re: Learning EXPLAIN

Hi, 2017-12-08 2:12 GMT+01:00 Flávio Henrique : > Hi experts! > > I read this nice article about Understanding EXPLAIN [1] weeks ago that > opened my mind about the tool, but it seems no enough to explain a lot of > plans that I see in this list. > Thanks. I often read responses to a plan that