pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tomas Vondra <tv@fuzzy.cz>
To: pgsql-performance@postgresql.org
Subject: Re: Hot Standby performance issue
Date: Wed, 23 Oct 2013 01:09:51 +0200
Message-ID: <526705BF.2080506@fuzzy.cz> (raw)
In-Reply-To: <1382478079418-5775526.post@n5.nabble.com>
References: <1382291901534-5775181.post@n5.nabble.com>
	<526460B7.3020008@fuzzy.cz>
	<1382367933794-5775257.post@n5.nabble.com>
	<52658780.1040002@fuzzy.cz>
	<1382390332002-5775332.post@n5.nabble.com>
	<5265A28E.4060601@fuzzy.cz>
	<1382396377294-5775349.post@n5.nabble.com>
	<5265B562.3040407@fuzzy.cz>
	<CABUevEyJrUEBRr-X4YbHmQZSaUhfFUHB_OcW-CzMQar4b6-scg@mail.gmail.com>
	<5266BBC3.90800@fuzzy.cz>
	<1382478079418-5775526.post@n5.nabble.com>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>

On 22.10.2013 23:41, sparikh wrote:
>>From Primary:
> 
> relname	relpages
> pg_toast_17673	1812819
> pg_toast_17594	161660
> pg_toast_17972	121902
> pg_toast_17587	77190
> pg_toast_18537	29108
> pg_toast_17578	26638
> pg_toast_17673_index	19984
> pg_toast_17868	14911
> pg_toast_17594_index	2208
> pg_toast_1072246	1922
> pg_toast_17587_index	1510
> pg_toast_17972_index	1399
> pg_statistic	911
> pg_toast_18694	883
> pg_toast_17578_index	375
> pg_attribute	336
> pg_toast_16475	332
> pg_toast_18537_index	321
> pg_proc	233
> pg_depend_depender_index	176
> 
>>From Secondary :
> ============
> relname	relpages
> pg_toast_17673	1812819
> pg_toast_17594	161660
> pg_toast_17972	121902
> pg_toast_17587	77190
> pg_toast_18537	29108
> pg_toast_17578	26638
> pg_toast_17673_index	19984
> pg_toast_17868	14911
> pg_toast_17594_index	2208
> pg_toast_1072246	1922
> pg_toast_17587_index	1510
> pg_toast_17972_index	1399
> pg_statistic	911
> pg_toast_18694	883
> pg_toast_17578_index	375
> pg_attribute	336
> pg_toast_16475	332
> pg_toast_18537_index	321
> pg_proc	233
> pg_depend_depender_index	176
> 
> Yes, result looks same both on primary and standby.

Yes. And it also shows that the really interesting tables (e.g.
pg_class) are not bloated.

Tomas


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



view thread (31+ messages)  latest in thread

Message-ID: <526705BF.2080506@fuzzy.cz>
Permalink:  ../526705BF.2080506@fuzzy.cz/
Also on:    postgresql.org/message-id/526705BF.2080506@fuzzy.cz

 · 

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 using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: tv@fuzzy.cz
  Subject: Re: Hot Standby performance issue
  In-Reply-To: <526705BF.2080506@fuzzy.cz>

* 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