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

help / color / mirror / Atom feed
From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Gerhard Hintermayer <gerhard.hintermayer@gmail.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Re: multiple hot standby streaming replication scenario with "rotating" the primary server
Date: Mon, 11 Apr 2011 14:06:40 -0500
Message-ID: <4DA30AF0020000250003C67D@gw.wicourts.gov> (raw)
In-Reply-To: <BANLkTinrWpuRRXYvH=JGkdq2ZnZJ35sPLw@mail.gmail.com>
References: <BANLkTinvBfV3MuL6k3PJWxbhTg2qwW4KQg@mail.gmail.com>
	<BANLkTiksRW05KZtJDs6Wf75wKD2R+bjGUg@mail.gmail.com>
	<4DA2E174020000250003C650@gw.wicourts.gov>
	<BANLkTikKGej=BmKaBUPcQu5z16J3J085vw@mail.gmail.com>
	<4DA2F31C020000250003C665@gw.wicourts.gov>
	<BANLkTik1CO13J8gj6HbYKqFn9FCWkHjDYw@mail.gmail.com>
	<4DA2FA41020000250003C672@gw.wicourts.gov>
	<BANLkTinrWpuRRXYvH=JGkdq2ZnZJ35sPLw@mail.gmail.com>

Gerhard Hintermayer <gerhard.hintermayer@gmail.com> wrote:
 
> Just checked my indices, looks like the only table in all my 5
> DB's that has a hash index is the one I ran tests on.
 
Well, actually that's pretty lucky.  If you'd tested with other
indexes, you might have gone live with the broken index.  I would
seriously consider converting the index to btree at this point, to
simplify life, unless you can show a significant performance benefit
with the hash index running your actual application mix.
 
> But the other thing is the huge amount of transfer volume when
> rsyncing the data dir from the new primary to set up the new
> replication slaves. But this should go away when I stop using
> REINDEX DATABASE, right ?
 
That should make a big difference, yeah.
 
-Kevin



view thread (13+ messages)  latest in thread

Message-ID: <4DA30AF0020000250003C67D@gw.wicourts.gov>
Permalink:  ../4DA30AF0020000250003C67D@gw.wicourts.gov/
Also on:    postgresql.org/message-id/4DA30AF0020000250003C67D@gw.wicourts.gov

 · 

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-admin@postgresql.org
  Cc: Kevin.Grittner@wicourts.gov, gerhard.hintermayer@gmail.com
  Subject: Re: Re: multiple hot standby streaming replication scenario with "rotating" the primary server
  In-Reply-To: <4DA30AF0020000250003C67D@gw.wicourts.gov>

* 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