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

help / color / mirror / Atom feed
From: Sergey Burladyan <eshkinkot@gmail.com>
To: Jeff Janes <jeff.janes@gmail.com>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: pgsql-performance\@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Looks like merge join planning time is too big, 55 seconds
Date: Sat, 03 Aug 2013 01:17:13 +0400
Message-ID: <87haf74wti.fsf@home.progtech.ru> (raw)
In-Reply-To: <874nb8uif7.fsf@seb.koffice.internal>
References: <CAJ2ymdjK-+LZHFY+cskRq98c_4F1PEfveOVNbNGpWL0Pczy5Ew@mail.gmail.com>
	<8761vpwid4.fsf@seb.koffice.internal>
	<CAMkU=1zyWZEC0YfQ0D4obWWHZqcLoLApUzf-f2+LOVH2ib=s_g@mail.gmail.com>
	<87li4lusvd.fsf@seb.koffice.internal>
	<CAMkU=1zuaFU7-DBJGawX+P+e4HjXmL+R_sxOLoB4Q18B5fRPHw@mail.gmail.com>
	<87li4l9j34.fsf@home.progtech.ru>
	<87k3k5kkup.fsf@home.progtech.ru>
	<20130802031914.GE5669@eldon.alvh.no-ip.org>
	<87haf8v2h8.fsf@seb.koffice.internal>
	<CAMkU=1yZvKht41LTrQB5UO7J=bO+beFLDLZ5E84_nRNLj20eRQ@mail.gmail.com>
	<874nb8uif7.fsf@seb.koffice.internal>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>

Sergey Burladyan <eshkinkot@gmail.com> writes:

> Hot standby:
...
> '          ->  Index Only Scan using items_user_id_idx on public.items  (cost=0.00..24165743.48 rows=200673143 width=8) (actual time=56064.499..56064.499 rows=1 loops=1)'
> '                Output: public.items.user_id'
> '                Index Cond: (public.items.user_id IS NOT NULL)'
> '                Heap Fetches: 8256426'
> '                Buffers: shared hit=3694164 read=6591224 written=121652'
> 'Total runtime: 56064.571 ms'
>
> Master:
>
...
> '          ->  Index Only Scan using items_user_id_idx on public.items  (cost=0.00..24166856.02 rows=200680528 width=8) (actual time=202.756..202.756 rows=1 loops=1)'
> '                Output: public.items.user_id'
> '                Index Cond: (public.items.user_id IS NOT NULL)'
> '                Heap Fetches: 0'
> '                Buffers: shared hit=153577 read=1'
> 'Total runtime: 202.786 ms'

Looks like visibility map is not replicated into slave somehow?

If it matters, Master was restarted yesterday, Standby was not.



-- 
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 (21+ messages)

Message-ID: <87haf74wti.fsf@home.progtech.ru>
Permalink:  ../87haf74wti.fsf@home.progtech.ru/
Also on:    postgresql.org/message-id/87haf74wti.fsf@home.progtech.ru

 · 

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: eshkinkot@gmail.com, jeff.janes@gmail.com, alvherre@2ndquadrant.com
  Subject: Re: Looks like merge join planning time is too big, 55 seconds
  In-Reply-To: <87haf74wti.fsf@home.progtech.ru>

* 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