From: "Lazaro Garcia" <lazaro3487@gmail.com>
To: "'Scott Marlowe'" <scott.marlowe@gmail.com>
Cc: <pgsql-admin@postgresql.org>
References: <003101d2b20c$7d2f4fd0$778def70$@gmail.com>
 <CAOR=d=39sGqmqo15YxarH4_dksxbxxQHCmcd_K30iWQK9X_mLg@mail.gmail.com>
 <CAOR=d=0R1GOBWQ8PEJf7EAc3wgTUX2MxggkJTLp3GgnGJyp3yQ@mail.gmail.com>
In-Reply-To: 
 <CAOR=d=0R1GOBWQ8PEJf7EAc3wgTUX2MxggkJTLp3GgnGJyp3yQ@mail.gmail.com>
Subject: Re: Help bad results with pgbench
Date: Mon, 10 Apr 2017 12:24:24 -0400
Message-ID: <003c01d2b216$ec6ee180$c54ca480$@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Thread-Index: AQGx2lWGDORi6gouGgTJzqrUpRlHtgGhaOugAcoPOJ2h5Rwy4A==
Content-Language: es-mx
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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]=20
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> wr=
ote:
> On Mon, Apr 10, 2017 at 9:09 AM, Lazaro Garcia <lazaro3487@gmail.com> wro=
te:
>> 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=20
> everything fits in RAM (or most of it) and is there because it's been=20
> accessed. When you reboot the machine is "warming up" so to speak the=20
> file system cache. Often just running select * from table is all you=20
> need to warm them up yourself.

So -i 200 is only a couple of gigs. You should fill up the file system cach=
e 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.


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