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

help / color / mirror / Atom feed

From: Glyn Astill <glynastill@yahoo.co.uk>
To: Merlin Moncure <mmoncure@gmail.com>
Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: david@lang.hm, Steve Clark <sclark@netwolves.com>
Cc: Joshua D. Drake <jd@commandprompt.com>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Linux: more cores = less concurrency.
Date: Tue, 12 Apr 2011 17:01:49 +0100 (BST)
Message-ID: <281886.96944.qm@web26007.mail.ukl.yahoo.com> (raw)
In-Reply-To: <BANLkTine3A9UUT4oYHTNA1tpda6ZtAmZ-A@mail.gmail.com>

--- On Tue, 12/4/11, Merlin Moncure <mmoncure@gmail.com> wrote:

> >>> Can we see some iobound and cpubound pgbench
> runs on both
> >>> servers?
> >>>
> >>
> >> Of course, I'll post when I've gotten to that.
> >
> > Ok, there's no writing going on -- so the i/o tets
> aren't necessary.
> > Context switches are also not too high -- the problem
> is likely in
> > postgres or on your end.
> >
> > However, I Would still like to see:
> > pgbench select only tests:
> > pgbench -i -s 1
> > pgbench -S -c 8 -t 500
> > pgbench -S -c 32 -t 500
> > pgbench -S -c 80 -t 500
> >
> > pgbench -i -s 500
> > pgbench -S -c 8 -t 500
> > pgbench -S -c 32 -t 500
> > pgbench -S -c 80 -t 500
> >
> > write out bench.sql with:
> > begin;
> > select * from heavy_seat_function();
> > select * from heavy_seat_function();
> > commit;
> >
> > pgbench -n bench.sql -c 8 -t 500
> > pgbench -n bench.sql -c 8 -t 500
> > pgbench -n bench.sql -c 8 -t 500
> 
> whoops:
> pgbench -n bench.sql -c 8 -t 500
> pgbench -n bench.sql -c 32 -t 500
> pgbench -n bench.sql -c 80 -t 500
> 
> merlin
> 

Right, here they are:

http://www.privatepaste.com/3dd777f4db

view thread (51+ messages)  latest in thread

Message-ID: <281886.96944.qm@web26007.mail.ukl.yahoo.com>
Permalink:  ../281886.96944.qm@web26007.mail.ukl.yahoo.com/
Also on:    postgresql.org/message-id/281886.96944.qm@web26007.mail.ukl.yahoo.com

copy link · copy postgr.es

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: glynastill@yahoo.co.uk, mmoncure@gmail.com, Kevin.Grittner@wicourts.gov, sclark@netwolves.com, jd@commandprompt.com, scott.marlowe@gmail.com
  Subject: Re: Linux: more cores = less concurrency.
  In-Reply-To: <281886.96944.qm@web26007.mail.ukl.yahoo.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