Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id CC8111337B67
	for <arpug-postgresql.org@mail.postgresql.org>;
	Sat,  7 May 2011 21:13:07 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024)
	with ESMTP id 63613-04 for <arpug-postgresql.org@mail.postgresql.org>;
	Sun,  8 May 2011 00:12:50 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mailserver.dialdata.com.ar (dialdata.com.ar [200.49.210.5])
	by mail.postgresql.org (Postfix) with ESMTP id 7056A1337990
	for <arpug@postgresql.org>; Sat,  7 May 2011 21:12:49 -0300 (ADT)
Received: from mailserver.dialdata.com.ar (localhost [127.0.0.1])
	by mailserver.dialdata.com.ar (Postfix) with ESMTP id E579B2E1CF;
	Sat,  7 May 2011 21:12:44 -0300 (ART)
Received: from 190-49-189-125.speedy.com.ar ([190.49.189.125])
	by mailserver.dialdata.com.ar:81
	with HTTP (HTTP/1.1 POST); Sat, 07 May 2011 21:12:44 -0300
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="=_2b51ba3b093fcfa696f9dd428fa75376"
Date: Sat, 07 May 2011 21:12:44 -0300
From: Ezequiel Lovelle <elovelle@dialdata.com.ar>
To: Fernando Hevia <fhevia@gmail.com>
Cc: Arpug <arpug@postgresql.org>
Subject: Re: Consulta
Organization: Teleservicios y Marketing S.A
In-Reply-To: <BANLkTikwSxC4Gu=7XKo_u_L3hKjGZ9X05A@mail.gmail.com>
References: <a525e92786a1a11f37ee3bbf813c1d69@dialdata.com.ar>
	<BANLkTim3pnqT0wC+z6x9gZGj7YdFm-PtSw@mail.gmail.com>
	<7e584a1df61e628d7b16d01a27d1a9d6@dialdata.com.ar>
	<BANLkTimB6XFr=4WUOueysXL62fW_8xbWWQ@mail.gmail.com>
	<3c82fe28fca089df4df103ce6823b1fd@dialdata.com.ar>
	<BANLkTi=k+VLwMUbTc1vJHK1KmnRiSO2_bQ@mail.gmail.com>
	<589af2fcfb2678bdf4db3045f370af4b@dialdata.com.ar>
	<BANLkTimSS6HryMYyrKfP4zgske62c9ZdeA@mail.gmail.com>
	<6726d28cf45b54e9d92355257775977c@dialdata.com.ar>
	<BANLkTikwSxC4Gu=7XKo_u_L3hKjGZ9X05A@mail.gmail.com>
Message-ID: <549d4022bc9e560e8a4d96f30827f0dc@dialdata.com.ar>
X-Sender: elovelle@dialdata.com.ar
User-Agent: DDM/0.5
X-DDM-MailScanner-Information: DDM
X-DDM-MailScanner-ID: E579B2E1CF.AF705
X-DDM-MailScanner: Found to be clean
X-DDM-MailScanner-From: elovelle@dialdata.com.ar
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.791 tagged_above=-10 required=5 tests=BAYES_50=0.8,
	HTML_MESSAGE=0.001, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201105/11
X-Sequence-Number: 595

--=_2b51ba3b093fcfa696f9dd428fa75376
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=UTF-8

  

Me voy a fijar, aunque la prueba la hice en los dos postgres de los
nodos, siendo practicamente idéntico en ambos. 

Y si ese fuese el caso,
¿porque cuando hago la query en la consola de postgres me la ejecuta en
cuestión de 1 segundo y escribió bien los datos en disco? yo creo que
estoy teniendo mal algo en postgres.conf 

te pego lo que tengo
modificado aver si se te ocurre algo. 

listen_addresses = '*'
wal_level
= archive
fsync = on
archive_mode = on
archive_command = 'exit
0'

maintenance_work_mem = 480MB
checkpoint_completion_target =
0.7
effective_cache_size = 5632MB
work_mem = 40MB
wal_buffers =
4MB
checkpoint_segments = 8
shared_buffers = 1920MB
max_connections =
400 

Gracias nuevamente. 

Saludos. 

On Sat, 7 May 2011 21:02:53
-0300, Fernando Hevia wrote: 

> 2011/5/7 Ezequiel Lovelle 
> 
>> Ok,
con fsync=on directamente a postgres me tardo:
>> 
>> #time php
script.php
>> real 5m34.471s
>> user 0m2.527s
>> sys 0m1.917s
>> 
>>
procs memory page disks faults cpu
>> r b w avm fre flt re pi po fr sr
ad4 ad6 in sy cs us sy id
>> ...
>> 0 0 0 2336M 7454M 8 0 0 0 0 0 810
810 2844 7114 22456 1 2 97
>> 0 0 0 2336M 7454M 632 0 0 0 649 0 496 497
1742 4577 13957 0 1 99
>> 0 0 0 2328M 7455M 265 0 0 0 662 0 189 189 677
1795 5696 0 0 99
>> 0 0 0 2328M 7455M 0 0 0 0 0 0 0 0 10 171 456 0 0
100
>> 0 0 0 2363M 7454M 414 0 0 0 161 0 4 4 33 6478 601 2 0 98
>> 0 0 0
2363M 7454M 0 0 0 0 0 0 0 0 7 151 456 0 0 100
>> 0 0 0 2363M 7454M 0 0 0
0 0 0 0 0 18 149 575 0 0 100
>> 0 0 0 2363M 7454M 0 0 0 0 0 0 3 3 10 147
485 0 0 100
>> 0 0 0 2363M 7454M 0 0 0 0 0 0 0 0 6 149 465 0 0 100
>> 0
0 0 2363M 7454M 2 0 0 0 0 0 0 0 7 152 489 0 0 100
>> 0 0 0 2363M 7454M 0
0 0 0 4 0 2 2 24 149 604 0 0 100
>> 0 0 0 2363M 7454M 0 0 0 0 8 0 9 9 22
147 562 0 0 100
> 
> En estos últimos registros, a partir del que pinté
en rojo, me da la impresión que el script terminó de ejecutar. Sin
embargo, la ocupación de discos sigue al 100%. 
> Indicaría que tenés
algo más ejecutando que te está ocupando todo el ancho de banda de I/O.



Links:
------
[1] mailto:elovelle@dialdata.com.ar

--=_2b51ba3b093fcfa696f9dd428fa75376
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset=UTF-8

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN">
<html><body>
<p>Me voy a fijar, aunque la prueba la hice en los dos postgres de los nodo=
s, siendo practicamente id&eacute;ntico en ambos.</p>
<p>Y si ese fuese el caso, &iquest;porque cuando hago la query en la consol=
a de postgres me la ejecuta en cuesti&oacute;n de 1 segundo y escribi&oacut=
e; bien los datos en disco? yo creo que estoy teniendo mal algo en postgres=
=2Econf</p>
<p>te pego lo que tengo modificado aver si se te ocurre algo.</p>
<p>listen_addresses =3D '*'<br />wal_level =3D archive<br />fsync =3D on<br=
 />archive_mode =3D on<br />archive_command =3D 'exit 0'<br /><br />mainten=
ance_work_mem =3D 480MB<br />checkpoint_completion_target =3D 0.7<br />effe=
ctive_cache_size =3D 5632MB<br />work_mem =3D 40MB<br />wal_buffers =3D 4MB=
<br />checkpoint_segments =3D 8<br />shared_buffers =3D 1920MB<br />max_con=
nections =3D 400</p>
<p>Gracias nuevamente.</p>
<p>Saludos.</p>
<p>On Sat, 7 May 2011 21:02:53 -0300, Fernando Hevia wrote:</p>
<blockquote type=3D"cite" style=3D"padding-left:5px; border-left:#1010ff 2p=
x solid; margin-left:5px; width:100%"><!-- html ignored --><!-- head ignore=
d --><!-- meta ignored --><br /><br />
<div class=3D"gmail_quote">2011/5/7 Ezequiel Lovelle <span>&lt;<a href=3D"m=
ailto:elovelle@dialdata.com.ar">elovelle@dialdata.com.ar</a>&gt;</span><br =
/>
<blockquote class=3D"gmail_quote" style=3D"margin: 0  0  0  .8ex; border-le=
ft: 1px  #ccc  solid; padding-left: 1ex;">
<div>
<p>Ok, con fsync=3Don directamente a postgres me tardo:<br /><br /><br />#t=
ime php script.php<br />real&nbsp;&nbsp;&nbsp; 5m34.471s<br />user&nbsp;&nb=
sp;&nbsp; 0m2.527s<br />sys&nbsp;&nbsp;&nbsp;&nbsp; 0m1.917s<br /><br />&nb=
sp;procs&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; memory&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
 page&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; disks&nbsp;&nbsp;&nbsp;&nbsp; =
faults&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cpu<br /> &nbsp;r b =
w&nbsp;&nbsp;&nbsp;&nbsp; avm&nbsp;&nbsp;&nbsp; fre&nbsp;&nbsp; flt&nbsp; r=
e&nbsp; pi&nbsp; po&nbsp;&nbsp;&nbsp; fr&nbsp; sr ad4 ad6&nbsp;&nbsp; in&nb=
sp;&nbsp; sy&nbsp;&nbsp; cs us sy id<br />&nbsp;...<br />&nbsp;0 0 0&nbsp;&=
nbsp; 2336M&nbsp; 7454M&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp; 0&nbsp;&nbsp;=
 0&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp; 0 810 810 2844 7114 =
22456&nbsp; 1&nbsp; 2 97<br />&nbsp;0 0 0&nbsp;&nbsp; 2336M&nbsp; 7454M&nbs=
p;&nbsp; 632&nbsp;&nbsp; 0&nbsp;&nbsp; 0&nbsp;&nbsp; 0&nbsp;&nbsp; 649&nbsp=
;&nbsp; 0 496 497 1742 4577 13957&nbsp; 0&nbsp; 1 99<br /> &nbsp;0 0 0&nbsp=
;&nbsp; 2328M&nbsp; 7455M&nbsp;&nbsp; 265&nbsp;&nbsp; 0&nbsp;&nbsp; 0&nbsp;=
&nbsp; 0&nbsp;&nbsp; 662&nbsp;&nbsp; 0 189 189&nbsp; 677 1795 5696&nbsp; 0&=
nbsp; 0 99<br />&nbsp;<span style=3D"color: #ff0000;">0 0 0&nbsp;&nbsp; 232=
8M&nbsp; 7455M&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp; 0&nbsp;&nbsp; 0&nbsp;&=
nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp; 0&nbsp;&nbsp; 0&nbsp;&nbsp; 0=
&nbsp;&nbsp; 10&nbsp; 171&nbsp; 456&nbsp; 0&nbsp; 0 100</span><br /> &nbsp;=
0 0 0&nbsp;&nbsp; 2363M&nbsp; 7454M&nbsp;&nbsp; 414&nbsp;&nbsp; 0&nbsp;&nbs=
p; 0&nbsp;&nbsp; 0&nbsp;&nbsp; 161&nbsp;&nbsp; 0&nbsp;&nbsp; 4&nbsp;&nbsp; =
4&nbsp;&nbsp; 33 6478&nbsp; 601&nbsp; 2&nbsp; 0 98<br />&nbsp;0 0 0&nbsp;&n=
bsp; 2363M&nbsp; 7454M&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp; 0&nbsp;&nbsp; =
0&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp; 0&nbsp;&nbsp; 0&nbsp;=
&nbsp; 0&nbsp;&nbsp;&nbsp; 7&nbsp; 151&nbsp; 456&nbsp; 0&nbsp; 0 100<br />&=
nbsp;0 0 0&nbsp;&nbsp; 2363M&nbsp; 7454M&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nb=
sp; 0&nbsp;&nbsp; 0&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp; 0&n=
bsp;&nbsp; 0&nbsp;&nbsp; 0&nbsp;&nbsp; 18&nbsp; 149&nbsp; 575&nbsp; 0&nbsp;=
 0 100<br /> &nbsp;0 0 0&nbsp;&nbsp; 2363M&nbsp; 7454M&nbsp;&nbsp;&nbsp;&nb=
sp; 0&nbsp;&nbsp; 0&nbsp;&nbsp; 0&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&n=
bsp;&nbsp; 0&nbsp;&nbsp; 3&nbsp;&nbsp; 3&nbsp;&nbsp; 10&nbsp; 147&nbsp; 485=
&nbsp; 0&nbsp; 0 100<br />&nbsp;0 0 0&nbsp;&nbsp; 2363M&nbsp; 7454M&nbsp;&n=
bsp;&nbsp;&nbsp; 0&nbsp;&nbsp; 0&nbsp;&nbsp; 0&nbsp;&nbsp; 0&nbsp;&nbsp;&nb=
sp;&nbsp; 0&nbsp;&nbsp; 0&nbsp;&nbsp; 0&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 6&n=
bsp; 149&nbsp; 465&nbsp; 0&nbsp; 0 100<br />&nbsp;0 0 0&nbsp;&nbsp; 2363M&n=
bsp; 7454M&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp; 0&nbsp;&nbsp; 0&nbsp;&nbsp=
; 0&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp; 0&nbsp;&nbsp; 0&nbsp;&nbsp; 0&nbs=
p;&nbsp;&nbsp; 7&nbsp; 152&nbsp; 489&nbsp; 0&nbsp; 0 100<br /> &nbsp;0 0 0&=
nbsp;&nbsp; 2363M&nbsp; 7454M&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp; 0&nbsp;=
&nbsp; 0&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp; 0&nbsp;&nbsp; =
2&nbsp;&nbsp; 2&nbsp;&nbsp; 24&nbsp; 149&nbsp; 604&nbsp; 0&nbsp; 0 100<br /=
>&nbsp;0 0 0&nbsp;&nbsp; 2363M&nbsp; 7454M&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&=
nbsp; 0&nbsp;&nbsp; 0&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp; 0=
&nbsp;&nbsp; 9&nbsp;&nbsp; 9&nbsp;&nbsp; 22&nbsp; 147&nbsp; 562&nbsp; 0&nbs=
p; 0 100<br /><br /></p>
</div>
</blockquote>
<div>En estos &uacute;ltimos registros, a partir del que pint&eacute; en ro=
jo, me da la impresi&oacute;n que el script termin&oacute; de ejecutar. Sin=
 embargo, la ocupaci&oacute;n de discos sigue al 100%.</div>
<div>Indicar&iacute;a que ten&eacute;s algo m&aacute;s ejecutando que te es=
t&aacute; ocupando todo el ancho de banda de I/O.</div>
<div></div>
<div></div>
</div>
</blockquote>
</body></html>

--=_2b51ba3b093fcfa696f9dd428fa75376--