Re: [HACKERS][PATCH]pg_buffercache add a buffer state column, Add fuction to decode buffer state

2017-11-20 Thread Masahiko Sawada
> If it is correct, I'll modify patch ASAP. I think it's better to register this patch to the next commit fest so as not to forget. >> -----Original Message- >> From: Andres Freund [mailto:and...@anarazel.de] >> Sent: Tuesday, November 14, 2017 6:07 PM >> To: M

RE: [HACKERS][PATCH]pg_buffercache add a buffer state column, Add fuction to decode buffer state

2017-11-14 Thread Moon Insung
ENT} - It's right? If it is correct, I'll modify patch ASAP. Regards. Moon. > -Original Message- > From: Andres Freund [mailto:and...@anarazel.de] > Sent: Tuesday, November 14, 2017 6:07 PM > To: Moon Insung > Cc: 'PostgreSQL Hackers' > Subject: Re: [

Re: [PATCH]pg_buffercache add a buffer state column, Add fuction to decode buffer state

2017-11-14 Thread Andres Freund
Hi, On 2017-11-14 17:57:00 +0900, Moon Insung wrote: > So I add a state column to pg_buffercache view so that I could print a value > indicating the state of the buffer. > This is outpu as an unit32 type, and examples are shown below. > - > postgres=# select * from pg_buffercache where buffe

[PATCH]pg_buffercache add a buffer state column, Add fuction to decode buffer state

2017-11-14 Thread Moon Insung
Dear Hackers. I'm studied PostgreSQL buffers for the development of new patches. In particular, using pg_buffercache, is can easily check the status of actual buffer. Bur there was one inconvenience. Pg_buffercache was also to check only the dirty state of the buffer. State of the buffer curren