Re: pg_stats and range statistics

2023-11-25 Thread Egor Rogov
Hi Alexander, On 25.11.2023 02:06, Alexander Korotkov wrote: In conclusion of all of the above, I decided to revise the patch and show the bounds histogram as it's stored in pg_statistic. I revised the docs correspondingly. So basically we returned to what it all has started from? I guess

Re: pg_stats and range statistics

2023-03-24 Thread Egor Rogov
On 24.03.2023 01:46, Tomas Vondra wrote: So if you could clean it up a bit, and do something about the two open items I mentioned (a bunch of tests on different array, I've added some tests to resgress/sql/rangetypes.sql, based on the same dataset that is used to test lower() and upper().

Re: pg_stats and range statistics

2023-03-20 Thread Egor Rogov
On 20.03.2023 22:27, Gregory Stark (as CFM) wrote: On Sun, 22 Jan 2023 at 18:22, Tomas Vondra wrote: I wonder if we have other functions doing something similar, i.e. accepting a polymorphic type and then imposing additional restrictions on it. Meh, there's things like array comparison

Re: pg_stats and range statistics

2023-01-23 Thread Egor Rogov
On 23.01.2023 13:01, Egor Rogov wrote: On 23.01.2023 02:21, Tomas Vondra wrote: On 1/22/23 22:33, Justin Pryzby wrote: On Sun, Jan 22, 2023 at 07:19:41PM +0100, Tomas Vondra wrote: On 1/21/23 19:53, Egor Rogov wrote: Hi Tomas, On 21.01.2023 00:50, Tomas Vondra wrote: This simply adds two

Re: pg_stats and range statistics

2023-01-23 Thread Egor Rogov
Hi, On 23.01.2023 02:21, Tomas Vondra wrote: On 1/22/23 22:33, Justin Pryzby wrote: On Sun, Jan 22, 2023 at 07:19:41PM +0100, Tomas Vondra wrote: On 1/21/23 19:53, Egor Rogov wrote: Hi Tomas, On 21.01.2023 00:50, Tomas Vondra wrote: This simply adds two functions, accepting/producing

Re: pg_stats and range statistics

2023-01-21 Thread Egor Rogov
Hi Tomas, On 21.01.2023 00:50, Tomas Vondra wrote: Hi Egor, While reviewing a patch improving join estimates for ranges [1] I realized we don't show stats for ranges in pg_stats, and I recalled we had this patch. I rebased the v2, and I decided to took a stab at showing separate histograms

Re: pg_stats and range statistics

2021-07-23 Thread Egor Rogov
Hi Tomas, On 12.07.2021 16:04, Tomas Vondra wrote: On 7/12/21 1:10 PM, Egor Rogov wrote: Hi, thanks for the review and corrections. On 11.07.2021 21:54, Soumyadeep Chakraborty wrote: Hello, This should have been added with [1]. Excerpt from the documentation: "pg_stats is also des

Re: pg_stats and range statistics

2021-07-12 Thread Egor Rogov
Hi, thanks for the review and corrections. On 11.07.2021 21:54, Soumyadeep Chakraborty wrote: Hello, This should have been added with [1]. Excerpt from the documentation: "pg_stats is also designed to present the information in a more readable format than the underlying catalog — at the cost

pg_stats and range statistics

2021-06-18 Thread Egor Rogov
uot;,"[2,12)","[3,13)","[4,14)","[5,15)","[6,16)","[7,17)","[8,18)","[9,19)","[10,20)"} Regards, Egor Rogov. diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index f517a7d4af..4d037b590e 1

Re: automatic analyze: readahead - add "IO read time" log message

2021-05-25 Thread Egor Rogov
directly, should call get_tablespace_maintenance_io_concurrency(). Ah, yeah, of course. Updated patch attached. I happened to notice that get_tablespace_io_concurrency() is called instead of get_tablespace_maintenance_io_concurrency(). It doesn't look right, no? Regards, Egor Rogov.

Re: BRIN cost estimate breaks geometric indexes

2020-01-20 Thread Egor Rogov
On 21.01.2020 0:00, Darafei "Komяpa" Praliaskouski wrote: Hi, Found out today that BRIN indexes don't really work for PostGIS and box datatypes. Since https://github.com/postgres/postgres/commit/7e534adcdc70866e7be74d626b0ed067c890a251 Postgres requires datatype to provide correlation

Re: [Proposal] Add accumulated statistics for wait event

2018-07-23 Thread Egor Rogov
). -- Egor Rogov Postgres Professional http://www.postgrespro.com