Created feature for to_date() conversion using patterns 'YYYY-WW', 'YYYY-WW-D', 'YYYY-MM-W' and 'YYYY-MM-W-D'

2019-10-08 Thread postgres
('W'). So, using the pattern '-MM-W-D' yields in: date string | to_date() --- '2018-12-5-1' | 2018-12-23 '2018-12-6-1' | 2018-12-30 '2019-1-1-1' | 2018-12-30 -> First day (Su) of the first week of the first mon

RE: Where can I find the doxyfile?

2023-10-06 Thread postgres
Sometime earlier, I created a filter to annotate regular C comments as doxy comments. I'll attach it along with a sample doxyfile for running it. Just in case it looks useful. I've never been a big fan of Doxygen, but it seems to have gotten better over time. Now that some IDEs display doxy comm

Re: [Ext:] Re: Stream Replication not working

2022-01-10 Thread Sushant Postgres
f| t | f | f > | f | f | -1 | | > | f| | 4571 > > pg_signal_backend | f| t | f | f > | f

回复: WAL Insertion Lock Improvements

2023-03-22 Thread adherent postgres
Hi Andres Freund This patch improves performance significantly,Commitfest 2023-03 is coming to an end,Is it not submitted yet since the patch still needs to be improved? Best wish 发件人: Nathan Bossart 发送时间: 2023年2月21日 13:49 收件人: Bharath Rupireddy 抄送: Andres F

Re: Add 64-bit XIDs into PostgreSQL 15

2022-12-30 Thread adherent postgres
Hi Maxim Orlov: >AFAICS, we have a following options: >1. Making "true" 64�Cbit XIDs. I.e. making every tuple have 64�Cbit xmin and >>xmax fields. >2. Put special in every page where base for XIDs are stored. This is what we >>have done in the current patch set. >3. Put base for XIDs in a fork.

回复: Add 64-bit XIDs into PostgreSQL 15

2022-12-09 Thread adherent postgres
Hi Chris Travers Robertmhaas said that the project Zheap is dead(https://twitter.com/andy_pavlo/status/1590703943176589312), which means that we cannot use Zheap to deal with the issue of xid wraparound and dead tuples in tables. The dead tuple issue is not a big deal because I can still u

Re: Add 64-bit XIDs into PostgreSQL 15

2022-12-09 Thread adherent postgres
l has no reason not to implement xid 64 bit. What about your opinion? Best whish 发件人: Aleksander Alekseev 发送时间: 2022年12月9日 20:49 收件人: pgsql-hackers@lists.postgresql.org 抄送: adherent postgres ; Chris Travers ; Chris Travers ; Bruce Momjian 主题: Re: Add 64-bit

回复: Add 64-bit XIDs into PostgreSQL 15

2022-12-09 Thread adherent postgres
opinion? Best whish 发件人: Pavel Borisov 发送时间: 2022年12月9日 22:13 收件人: adherent postgres 抄送: Aleksander Alekseev ; pgsql-hackers@lists.postgresql.org ; Chris Travers ; Chris Travers ; Bruce Momjian 主题: Re: Add 64-bit XIDs into PostgreSQL 15 Hi, Adherent! On Fri, 9