pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gauri Kanekar <meetgaurikanekar@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Hot Issue
Date: Wed, 2 Jul 2008 18:01:23 +0530
Message-ID: <7e4ba9550807020531w5480956fs2a1b5b630babda41@mail.gmail.com> (raw)

Hi all,

We have upgraded our database server to postgres 8.3.1 on 28th June.

Checked out the performance of Hot on 30th June :

    relname              n_tup_ins   n_tup_upd   n_tup_del   n_tup_hot_upd
 n_live_tup   n_dead_tup   *table1* *15509156* *2884653* *0* *2442823* *
15509158* *68046*  table2 434585 718472 0 642336 434703 16723  table3 105546
252143 0 233078 105402 4922  table4 7303628 96098 176790 23445 7126838 3443
table5 11117045 22245 0 16910 11117045 440

Checked the performance of Hot on 2nd July :

    relname              n_tup_ins   n_tup_upd   n_tup_del   n_tup_hot_upd
 n_live_tup   n_dead_tup   *table1**15577724* *6237242* *0* *2924948* *
18460676* *131103*  table2 435558 1579613 0 763397 1171497 42476  table3
105814 540997 0 273443 355287 14184  table4 7614752 219329 513268 41053
7424721 62  table5 11184309 47665 0 21198 11206296 745


































Performance of Hot was much better on 30June as compared to 2nd July.

Can anybody , help out over here.

~ Gauri
relname
 n_tup_ins
 n_tup_upd
 n_tup_del
 n_tup_hot_upd
 n_live_tup
 n_dead_tup


-- 
Regards
Gauri

view thread (12+ messages)  latest in thread

Message-ID: <7e4ba9550807020531w5480956fs2a1b5b630babda41@mail.gmail.com>
Permalink:  ../7e4ba9550807020531w5480956fs2a1b5b630babda41@mail.gmail.com/
Also on:    postgresql.org/message-id/7e4ba9550807020531w5480956fs2a1b5b630babda41@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: meetgaurikanekar@gmail.com
  Subject: Re: Hot Issue
  In-Reply-To: <7e4ba9550807020531w5480956fs2a1b5b630babda41@mail.gmail.com>
  References: <7e4ba9550807020531w5480956fs2a1b5b630babda41@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox