From: Sven R. Kunze <srkunze@mail.de>
To: Jarek <jarek@poczta.srv.pl>
To: pgsql-performance@postgresql.org
Subject: Re: More cores or higer frequency ?
Date: Tue, 23 May 2017 22:49:58 +0200
Message-ID: <1c5c89f2-9b3a-69f2-af2a-c905affc1944@mail.de> (raw)
In-Reply-To: <1495570454.6168.44.camel@sem-jarek-01.prv>
References: <1495564174.6168.10.camel@sem-jarek-01.prv>
<CAEfWYyw6d72mpLiaaOHbAjhNsGR+_pM3saTY8EWw5Y+3szwKWg@mail.gmail.com>
<1495570454.6168.44.camel@sem-jarek-01.prv>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
On 23.05.2017 22:14, Jarek wrote:
> I have pool of clients (~30) inserting to database about 50 records per
> second (in total from all clients) and small numer (<10) clients
> querying database for those records once per 10s.
> Other queries are rare and irregular.
> The biggest table has ~ 100mln records (older records are purged
> nightly). Database size is ~13GB.
> I near future I'm expecting ~150 clients and 250 inserts per second and
> more clients querying database.
> Server is handling also apache with simple web application written in
> python.
> For the same price, I can get 8C/3.2GHz or 14C/2.6GHz. Which one will be
> better ?
>
>
>
Hi Jarek,
in case of your increasing parallel requirements (more clients, more
inserts), I would tend to the 14C setup. However, as usual take this
with a grain of salt. My word is not a guarantee for success in this case.
Best would be to setup a test scenario where you can simulate with both
hardware setups.
Regards,
Sven
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
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: srkunze@mail.de, jarek@poczta.srv.pl
Subject: Re: More cores or higer frequency ?
In-Reply-To: <1c5c89f2-9b3a-69f2-af2a-c905affc1944@mail.de>
* 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