Postgres Pro
Downloads
Home   >   mailing lists

Re: EXPLAIN (ANALYZE, BUFFERS) - puzzling numbers for a simple query. - Mailing list pgsql-general

From Tom Lane
Subject Re: EXPLAIN (ANALYZE, BUFFERS) - puzzling numbers for a simple query.
Date
Msg-id 143204.1622814183@sss.pgh.pa.us
Whole thread Raw
In response to Re: EXPLAIN (ANALYZE, BUFFERS) - puzzling numbers for a simple query.  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: EXPLAIN (ANALYZE, BUFFERS) - puzzling numbers for a simple query.  (Pól Ua Laoínecháin <linehanp@tcd.ie>)
List pgsql-general
Tree view 
Laurenz Albe <laurenz.albe@cybertec.at> writes:
> On Sat, 2021-06-05 at 00:12 +1200, David Rowley wrote:
>> As for the call to generate_series, you're not likely to ever get any
>> great estimation from that.

> "generate_series" has a support function from v12 on:

True, but I don't think it can do anything with non-constant inputs,
as we have in the OP's case.

            regards, tom lane

pgsql-general by date:

Previous
From: Vijaykumar Jain
Date:
Subject: Re: strange behavior of WAL files
Next
From: Tom Lane
Date:
Subject: Re: strange behavior of WAL files