Re: Multi-transactional statements and statistics for autovacuum

2024-07-07 Thread Egor Rogov
Hello everybody, On 12.06.2024 20:13, Igor V.Gnatyuk wrote: Hello. Before the advent of procedures in PostgreSQL 11 that can manage transactions, there could only be one transaction in one statement. Hence the end of the transaction also meant the end of the statement. Apparently, this is

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