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

help / color / mirror / Atom feed
From: Gregory Stark <stark@enterprisedb.com>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Greg Smith <gsmith@gregsmith.com>
Cc: Guillaume Smet <guillaume.smet@gmail.com>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Cc: Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>
Cc: Devrim GÜNDÜZ <devrim@commandprompt.com>
Subject: Re: More shared buffers causes lower performances
Date: Thu, 27 Dec 2007 14:51:40 +0000
Message-ID: <87fxxow5qb.fsf@oxford.xeocode.com> (raw)
In-Reply-To: <20071227132002.GC5709@alvh.no-ip.org>
References: <1d4e0c10712251606q6f9503deye3da4b68c51bf5e@mail.gmail.com>
	<1198668065.4221.288.camel@ebony.site>
	<1d4e0c10712260741w1f141fd6x2f482143d526ad48@mail.gmail.com>
	<Pine.GSO.4.64.0712261316580.11546@westnet.com>
	<1d4e0c10712261352j2fbcd25ek1270331468d824b4@mail.gmail.com>
	<1d4e0c10712261453s4b171452g8aa30a1124f8fff1@mail.gmail.com>
	<Pine.GSO.4.64.0712261816520.16448@westnet.com>
	<29359.1198735829@sss.pgh.pa.us>
	<20071227132002.GC5709@alvh.no-ip.org>

"Alvaro Herrera" <alvherre@commandprompt.com> writes:

> Tom Lane escribió:
>
>> Currently the docs say that --enable-cassert
>> 
>>          Enables <firstterm>assertion</> checks in the server, which test for
>>          many <quote>cannot happen</> conditions.  This is invaluable for
>>          code development purposes, but the tests slow things down a little.
>> 
>> Maybe we ought to put that more strongly --- s/a little/significantly/,
>> perhaps?
>
> I don't think it will make any difference, because people don't read
> configure documentation.  They read configure --help.

Fwiw I think you're all getting a bit caught up in this one context. While the
slowdown is significant when you take out the stopwatch, under normal
interactive use you're not going to notice your queries being especially slow.

-- 
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's On-Demand Production Tuning



view thread (26+ messages)  latest in thread

Message-ID: <87fxxow5qb.fsf@oxford.xeocode.com>
Permalink:  ../87fxxow5qb.fsf@oxford.xeocode.com/
Also on:    postgresql.org/message-id/87fxxow5qb.fsf@oxford.xeocode.com

 · 

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: stark@enterprisedb.com, alvherre@commandprompt.com, tgl@sss.pgh.pa.us, gsmith@gregsmith.com, guillaume.smet@gmail.com, stefan@kaltenbrunner.cc, devrim@commandprompt.com
  Subject: Re: More shared buffers causes lower performances
  In-Reply-To: <87fxxow5qb.fsf@oxford.xeocode.com>

* 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