Fabien, Thanks for your comment. I'll check them and try to examine what is the same and what is different. -- Takashi Horikawa NEC Corporation Knowledge Discovery Research Laboratories
> -----Original Message----- > From: pgsql-hackers-ow...@postgresql.org > [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Fabien COELHO > Sent: Thursday, September 10, 2015 7:33 PM > To: Horikawa Takashi(堀川 隆) > Cc: pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] Partitioned checkpointing > > > > > I don't feel that another source of the performance dip has been > > heartily addressed; full-page-write rush, which I call here, would be > a major issue. > > That is, the average size of transaction log (XLOG) records jumps up > > sharply immediately after the beginning of each checkpoint, resulting > > in the saturation of WAL write path including disk(s) for > > $PGDATA/pg_xlog and WAL buffers. > > On this point, you may have a look at this item: > > https://commitfest.postgresql.org/5/283/ > > -- > Fabien. > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers
smime.p7s
Description: S/MIME cryptographic signature
