From: | Karthik Viswanathan <krthkv26(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | live and dead tuples are zero on slave running on tmpfs |
Date: | 2015-08-19 14:55:02 |
Message-ID: | CAEsRYzS_ySTek8fKG_T76bVX6eS7Bq4_H+Dfo1bjk3BJSEo6Fw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I have a master slave (read replica) setup running pg 9.4.4. I'm
trying to find the dead tuples out both the master and slave
Here's what it looks like on master:
# select relname ,n_live_tup ,n_dead_tup from pg_stat_user_tables;
relname | n_live_tup | n_dead_tup
------------------+------------+------------
test_52 | 4998366 | 0
test_v2 | 25182728 | 4086591
test_1mrows | 1000127 | 0
That seems legit because I did an update to ~4million rows just before this.
Here's what it looks on slave though
#select relname ,n_live_tup ,n_dead_tup from pg_stat_user_tables;
relname | n_live_tup | n_dead_tup
------------------+------------+------------
test_52 | 0 | 0
test_v2 | 0 | 0
test_1mrows | 0 | 0
the postgres data directory on the slave is configured to a tmpfs
mounted store. Would this cause it to have zero live & dead tuples ?
postgres version on master and slave:
PostgreSQL 9.4.4 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu
4.8.2-19ubuntu1) 4.8.2, 64-bit
-- Karthik
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Smith | 2015-08-19 15:05:02 | Re: retrieve subset of a jsonb object with a list of keys |
Previous Message | Igor Neyman | 2015-08-19 13:52:20 | Re: PostgreSQL customer list |