Re: [HACKERS] Logical replication existing data copy

2017-03-29 Thread Erik Rijkers
On 2017-03-09 11:06, Erik Rijkers wrote: I use three different machines (2 desktop, 1 server) to test logical replication, and all three have now at least once failed to correctly synchronise a pgbench session (amidst many succesful runs, of course) (At the moment using tese patches for tes

[HACKERS] [PATCH] Remove trailing spaces

2017-03-29 Thread Alexander Law
Hello, Please consider committing the attached patches to remove trailing spaces in strings in the source code. One patch is for localizable messages, and the other is just for consistency (less important). -- Alexander Lakhin Postgres Professional: http://www.postgrespro.com The Russian Post

Re: [HACKERS] Allow interrupts on waiting standby

2017-03-29 Thread Tsunakawa, Takayuki
Hi, Michael, From: pgsql-hackers-ow...@postgresql.org > [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Michael Paquier > What do you think about the updated version attached? I reviewed this patch. Here are some comments and questions: (1) monitoring.sgml The new row needs to be pla

Re: [HACKERS] Partitioned tables and relfilenode

2017-03-29 Thread Kyotaro HORIGUCHI
Hello, At Wed, 29 Mar 2017 15:40:20 +0900, Amit Langote wrote in > On 2017/03/27 23:27, Robert Haas wrote: > > On Thu, Mar 23, 2017 at 8:54 PM, Amit Langote > > wrote: > >> On 2017/03/23 23:47, Amit Langote wrote: > >>> On Thu, Mar 23, 2017 at 11:27 PM, Maksim Milyutin > >>> wrote: > Hi

Re: [HACKERS] Patch: Write Amplification Reduction Method (WARM)

2017-03-29 Thread Pavan Deolasee
On Wed, Mar 29, 2017 at 12:02 PM, Amit Kapila wrote: > On Wed, Mar 29, 2017 at 11:52 AM, Amit Kapila > wrote: > > On Tue, Mar 28, 2017 at 10:35 PM, Pavan Deolasee > > wrote: > >> > >> On Tue, Mar 28, 2017 at 7:04 PM, Amit Kapila > >> wrote: > >>> > >>> For such an heap insert, we will pass >

Re: [HACKERS] On How To Shorten the Steep Learning Curve Towards PG Hacking...

2017-03-29 Thread Amit Langote
On 2017/03/29 12:36, Craig Ringer wrote: > On 29 March 2017 at 10:53, Amit Langote wrote: >> Hi, >> >> On 2017/03/28 15:40, Kang Yuzhe wrote: >>> Thanks Tsunakawa for such an informative reply. >>> >>> Almost all of the docs related to the internals of PG are of introductory >>> concepts only. >>>

Re: [HACKERS] [patch] reorder tablespaces in basebackup tar stream for backup_label

2017-03-29 Thread Michael Banck
Hi, Am Mittwoch, den 29.03.2017, 15:22 +0900 schrieb Michael Paquier: > On Wed, Mar 29, 2017 at 3:56 AM, Fujii Masao wrote: > > If your need other information except START WAL LOCATION at the beginning of > > base backup and they are very useful for many third-party softwares, > > you can add the

Re: [HACKERS] [POC] A better way to expand hash indexes.

2017-03-29 Thread Mithun Cy
On Wed, Mar 29, 2017 at 10:12 AM, Amit Kapila wrote: >> I wonder if we should consider increasing >> SPLITPOINT_GROUPS_WITH_ONLY_ONE_PHASE somewhat. For example, split >> point 4 is responsible for allocating only 16 new buckets = 128kB; >> doing those in four groups of two (16kB) seems fairly p

Re: [HACKERS] Prologue of set_append_rel_size() and partitioned tables

2017-03-29 Thread Ashutosh Bapat
On Wed, Mar 29, 2017 at 12:23 PM, Amit Langote wrote: > On 2017/03/29 15:20, Ashutosh Bapat wrote: >> The prologue of set_append_rel_size() mentions >> >> * Note that in the inheritance case, >> * the first member relation is actually the same table as is mentioned in >> * the parent RTE

Re: [HACKERS] On How To Shorten the Steep Learning Curve Towards PG Hacking...

2017-03-29 Thread Kang Yuzhe
Thanks you all for pointing me to useful docs on PG kernel stuff as well as for being sympathetic with me and the newbie question that appears to be true and interesting but yet be addressed by PG experts. Last but not least, *Craig Ringer*, you just nailed it!! You also made me feel and think tha

<    1   2