Re: [HACKERS] Typo in bufmgr.c that result in waste of memory

2016-02-19 Thread Takashi Horikawa
hould fix it, but not backpatch. I agree that backpatch is unnecessary. I hope it will be fixed for the current development version at some suitable opportunity. Best regards, Takashi Horikawa NEC Corporation Knowledge Discovery Research Laboratories > -Original Message- > From: pgsql-hackers-ow...

[HACKERS] Typo in bufmgr.c that result in waste of memory

2016-02-18 Thread Takashi Horikawa
= hash_create("PrivateRefCount", 100, _ctl, HASH_ELEM | HASH_BLOBS); } Attached patch is for the latest development version at the git repository. -- Takashi Horikawa NEC Corporation Knowledge Discovery Research Laboratories correction_of_PrivateRefC

Re: [HACKERS] Partitioned checkpointing

2015-09-14 Thread Takashi Horikawa
s an example. And also, 'Partitioned checkpointing' is worth to study why it is effective in pgbench executions. By studying it, it may lead to devising better ways. -- Takashi Horikawa NEC Corporation Knowledge Discovery Research Laboratories > -Original Message- > From: pgsql-hackers-ow

Re: [HACKERS] Partitioned checkpointing

2015-09-12 Thread Takashi Horikawa
probably worth than bug-fix version. Best regards. -- 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 Takashi Horikawa > Sent: S

Re: [HACKERS] Partitioned checkpointing

2015-09-12 Thread Takashi Horikawa
> As to 'partitioned checkpointing' case, the results shown in that graph > is probably worth than bug-fix version. ^ worse Sorry for typo. -- Takashi Horikawa NEC Corporation Knowledge Discovery Research Laboratories > -Original Message---

Re: [HACKERS] Partitioned checkpointing

2015-09-11 Thread Takashi Horikawa
I think it's likely that the patch will have only a very small effect if > applied ontop of Fabien's patch (which'll require some massaging I'm sure). It may be true or not. Who knows? I think only detail experimentations tell the truth. Best regards. -- Takashi Horikawa NEC Corporation Know

Re: [HACKERS] Partitioned checkpointing

2015-09-11 Thread Takashi Horikawa
itions' is fairly simple. Best regards. -- Takashi Horikawa NEC Corporation Knowledge Discovery Research Laboratories > -Original Message- > From: Simon Riggs [mailto:si...@2ndquadrant.com] > Sent: Friday, September 11, 2015 10:57 PM > To: Fabien COELHO > Cc: Horikawa Tak

Re: [HACKERS] Partitioned checkpointing

2015-09-11 Thread Takashi Horikawa
mgr.h to xlog.h. It would be also trivial. Best regards. -- Takashi Horikawa NEC Corporation Knowledge Discovery Research Laboratories partitioned-checkpointing-v2.patch Description: Binary data smime.p7s Description: S/MIME cryptographic signature

[HACKERS] Partitioned checkpointing

2015-09-10 Thread Takashi Horikawa
estigation aiming to implement in future PostgreSQL. -- Takashi Horikawa NEC Corporation Knowledge Discovery Research Laboratories partitioned-checkpointing.patch Description: Binary data smime.p7s Description: S/MIME cryptographic signature

Re: [HACKERS] Partitioned checkpointing

2015-09-10 Thread Takashi Horikawa
raid1 of 2 SSDs for $PGDATA (other than pg_xlog) 'raid1' is wrong and 'raid0' is correct. -- Takashi Horikawa NEC Corporation Knowledge Discovery Research Laboratories > -Original Message- > From: Alvaro Herrera [mailto:pgsql-hackers-ow...@postgresql.org] > Sent: Friday, Sep

Re: [HACKERS] Partitioned checkpointing

2015-09-10 Thread Takashi Horikawa
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-h

Re: [HACKERS] patch: prevent user from setting wal_buffers over 2GB bytes

2015-08-04 Thread Takashi Horikawa
) (XLogCtl-pages + nextidx * (Size) XLOG_BLCKSZ); ' in AdvanceXLInsertBuffer(XLogRecPtr upto, bool opportunistic) , etc. Only exception is 'page = XLogCtl-pages[firstIdx * XLOG_BLCKSZ];' in StartupXLOG(void) -- Takashi Horikawa NEC Corporation Knowledge Discovery Research Laboratories

Re: [HACKERS] patch: prevent user from setting wal_buffers over 2GB bytes

2015-08-03 Thread Takashi Horikawa
that applying the patch makes 'wal_buffers = 4GB' works fine, while original PostgreSQL-9.4.4 results in core dump (segfault). I'll be happy if anyone reconfirm this. -- Takashi Horikawa NEC Corporation Knowledge Discovery Research Laboratories -Original Message- From: pgsql-hackers-ow