Re: PG defaults and performance (was Re: Unexpectedly high disk space usage RESOLVED (Manual reindex/vacuum))

From: Chris Angelico <rosuav(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: PG defaults and performance (was Re: Unexpectedly high disk space usage RESOLVED (Manual reindex/vacuum))
Date: 2012-11-10 22:14:33
Message-ID: CAPTjJmo61o_XP-EypRa+FJBPDW5QAQRe1k7O3MYaT0YKDdSpjw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Nov 11, 2012 at 8:05 AM, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
> Totally not. With default settings and default pgbench, the easiest
> way for host B to beat host A is by lying about the durability of
> fsync.

True. Without the ability to brutally cut the power to a cloud
instance or other remote (and in some cases possibly virtualized)
server, it's practically impossible to test that. We're basically
relying on replication and hoping that three instances (master and two
slaves) don't go down simultaneously, which is hardly a guarantee.

ChrisA

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2012-11-10 22:20:59 Re: Unexpectedly high disk space usage RESOLVED (Manual reindex/vacuum)
Previous Message Scott Marlowe 2012-11-10 22:08:52 Re: Unexpectedly high disk space usage RESOLVED (Manual reindex/vacuum)