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

help / color / mirror / Atom feed
From: Lazaro Garcia <lazaro3487@gmail.com>
To: 'Scott Marlowe' <scott.marlowe@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Help bad results with pgbench
Date: Mon, 10 Apr 2017 12:24:24 -0400
Message-ID: <003c01d2b216$ec6ee180$c54ca480$@gmail.com> (raw)
In-Reply-To: <CAOR=d=0R1GOBWQ8PEJf7EAc3wgTUX2MxggkJTLp3GgnGJyp3yQ@mail.gmail.com>
References: <003101d2b20c$7d2f4fd0$778def70$@gmail.com>
	<CAOR=d=39sGqmqo15YxarH4_dksxbxxQHCmcd_K30iWQK9X_mLg@mail.gmail.com>
	<CAOR=d=0R1GOBWQ8PEJf7EAc3wgTUX2MxggkJTLp3GgnGJyp3yQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>

Thank you very much for the answer, your righ testing it again durin 30 min and the tps was increasing over the time.

Regards and thank you for the help.


-----Mensaje original-----
De: Scott Marlowe [mailto:scott.marlowe@gmail.com] 
Enviado el: lunes, 10 de abril de 2017 11:56 a. m.
Para: Lazaro Garcia
CC: pgsql-admin@postgresql.org
Asunto: Re: [ADMIN] Help bad results with pgbench

On Mon, Apr 10, 2017 at 9:48 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Mon, Apr 10, 2017 at 9:09 AM, Lazaro Garcia <lazaro3487@gmail.com> wrote:
>> Good morning everyone.
>>
>> I'm having the following problem with pgbench and test again:
>
> Yeah this is the file system cache warm vs cold. In the first instance 
> everything fits in RAM (or most of it) and is there because it's been 
> accessed. When you reboot the machine is "warming up" so to speak the 
> file system cache. Often just running select * from table is all you 
> need to warm them up yourself.

So -i 200 is only a couple of gigs. You should fill up the file system cache pretty fast.

Just keep running pgbench and the numbers should climb over time.

Or you can look into the pg_prewarm module.

https://www.postgresql.org/docs/9.4/static/pgprewarm.html

--
To understand recursion, one must first understand recursion.



-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



view thread (4+ messages)

Message-ID: <003c01d2b216$ec6ee180$c54ca480$@gmail.com>
Permalink:  ../003c01d2b216$ec6ee180$c54ca480$@gmail.com/
Also on:    postgresql.org/message-id/003c01d2b216$ec6ee180$c54ca480$@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-admin@postgresql.org
  Cc: lazaro3487@gmail.com, scott.marlowe@gmail.com
  Subject: Re: Help bad results with pgbench
  In-Reply-To: <003c01d2b216$ec6ee180$c54ca480$@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