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

help / color / mirror / Atom feed
From: Ivan Voras <ivoras@freebsd.org>
To: Lefteris <lsidir@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Air-traffic benchmark
Date: Thu, 7 Jan 2010 16:57:18 +0100
Message-ID: <9bbcef731001070757s61b12ac7yfbf64ca383862675@mail.gmail.com> (raw)
In-Reply-To: <852badbc1001070705w45ed93d6m385ea50da2221959@mail.gmail.com>
References: <852badbc1001070438j36eb10d3qa22398ffcbef405f@mail.gmail.com>
	<4B45E36E.4040706@tweakers.net>
	<852badbc1001070547p48b47175vf87efc473e3bd41b@mail.gmail.com>
	<26014999.20100107150535@erwied.eu>
	<852badbc1001070610p698dc3cfr4628b1e7768990e6@mail.gmail.com>
	<20100107141423.GC4315@alvh.no-ip.org>
	<852badbc1001070623m5d901c42k50bb808409141ca4@mail.gmail.com>
	<hi4sde$k7p$1@ger.gmane.org>
	<852badbc1001070705w45ed93d6m385ea50da2221959@mail.gmail.com>

2010/1/7 Lefteris <lsidir@gmail.com>:
> On Thu, Jan 7, 2010 at 3:51 PM, Ivan Voras <ivoras@freebsd.org> wrote:
>> On 7.1.2010 15:23, Lefteris wrote:
>>
>>> I think what you all said was very helpful and clear! The only part
>>> that I still disagree/don't understand is the shared_buffer option:))
>>
>> Did you ever try increasing shared_buffers to what was suggested (around
>> 4 GB) and see what happens (I didn't see it in your posts)?
>
> No I did not to that yet, mainly because I need the admin of the
> machine to change the shmmax of the kernel and also because I have no
> multiple queries running. Does Seq scan uses shared_buffers?

Everything uses shared_buffers, even things that do not benefit from
it. This is because shared_buffers is the part of the general database
IO - it's unavoidable.



view thread (34+ messages)  latest in thread

Message-ID: <9bbcef731001070757s61b12ac7yfbf64ca383862675@mail.gmail.com>
Permalink:  ../9bbcef731001070757s61b12ac7yfbf64ca383862675@mail.gmail.com/
Also on:    postgresql.org/message-id/9bbcef731001070757s61b12ac7yfbf64ca383862675@mail.gmail.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: ivoras@freebsd.org, lsidir@gmail.com
  Subject: Re: Air-traffic benchmark
  In-Reply-To: <9bbcef731001070757s61b12ac7yfbf64ca383862675@mail.gmail.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