Re: Checkpoints questions
От | Devi |
---|---|
Тема | Re: Checkpoints questions |
Дата | |
Msg-id | 011101c87de8$8dbf2c60$3f0110ac@devco обсуждение исходный текст |
Ответ на | Checkpoints questions (Henrik <henke@mac.se>) |
Список | pgsql-general |
Hi, Hope this helps http://www.westnet.com/~gsmith/content/postgresql/chkp-bgw-83.htm Thanks DEVI.G ----- Original Message ----- From: "Henrik" <henke@mac.se> To: <pgsql-general@postgresql.org> Sent: Tuesday, March 04, 2008 3:28 PM Subject: [GENERAL] Checkpoints questions > Hi list, > > I'm using 8.3 and I've started looking at the new checkpoint features. > > As a starter does anyone have some clues how to analyse this: > > db=# select * from pg_stat_bgwriter; > checkpoints_timed | checkpoints_req | buffers_checkpoint | buffers_clean > | maxwritten_clean | buffers_backend | buffers_alloc > -------------------+-----------------+-------------------- > +---------------+------------------+-----------------+--------------- > 118 | 435 | 1925161 | 126291 > | 7 | 1397373 | 2665693 > > > Thanks! > //Henke > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > > > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: > 269.21.4/1309 - Release Date: 3/3/2008 6:50 PM > >
В списке pgsql-general по дате отправления: