DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type;
	b=Kws67uy54TMZFlQ58S9Jo+5cfHDfGSZ695jAKQ2k/uLMgdjCmFEyhYnlj4XPtpHmwzoF+7yOeq+HhdDNiG/6b+h5xq+jBkcnnTkNogYJufXXnjFAOlKiQ0AhK+lBbTsMtW9phr9DeT+oXZQVxbqNQ1yYyDdrJ3RgI7OCj9L5CWY=;
Message-ID: <25247.43880.qm@web65408.mail.ac4.yahoo.com>
References: <132275.30531.qm@web65411.mail.ac4.yahoo.com>
	<AANLkTinUWnfp8v0s2dugH=M1fwDBkUExiSsJj81Yst_s@mail.gmail.com>
Date: Wed, 27 Oct 2010 09:12:24 -0700 (PDT)
From: Divakar Singh <dpsmails@yahoo.com>
Subject: Re: Postgres insert performance and storage requirement compared to
	Oracle
To: David Wilson <david.t.wilson@gmail.com>
Cc: Steve Singer <ssinger@ca.afilias.info>, jd@commandprompt.com,
	pgsql-performance@postgresql.org
In-Reply-To: <AANLkTinUWnfp8v0s2dugH=M1fwDBkUExiSsJj81Yst_s@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-573496202-1288195944=:43880"

--0-573496202-1288195944=:43880
Content-Type: text/plain; charset=us-ascii


>    for (;  i<howmany;i++ )
>    {
>
>    sprintf (query, "INSERT INTO aaaa(a, b, c, d, e, f, g, h, j, k, l, m, n, p) 
>VALUES (67, 'ABRAKADABRA', 'ABRAKADABRA', 'ABRAKADABRA', '1-Dec-2010', 
>'ABRAKADABRA', 'ABRAKADABRA',  'ABRAKADABRA', '1-Dec-2010', 99999, 99999, %d, 
>9999, 
>'ABRAKADABRAABRAKADABRAABRAKADABRAABRAKADABRAABRAKADABRAABRAKADABRAABRAKADABRAABRAKADABRAABRAKADABRAABRAKADABRAABRAKADABRAABRAKADABRA')",
> i);
>
>    res = PQexec(conn, query);
>
>      if (PQresultStatus(res) != PGRES_COMMAND_OK)
>        {
>          cout<<"error at iteration "<<i<<":"<<PQresultErrorMessage(res)<<endl;
>                  PQclear(res);
>          break;
>         }
>        //PQclear(res);
>
>
>    }
>

>Why is that PQclear(res) commented out? You're leaking result status for every 
>insert.


I did that purposely to see if cleanup part is contributing to  any performance 
loss.
Right now in my test, memory leak is not a concern for me but performance is. 
Though I understand that memory leak can also result in performance loss  if 
leak is too much.
However, in this case, commenting or uncommenting this statement did not  cause 
any change in performance.


--0-573496202-1288195944=:43880
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial,helvetica,sans-serif;font-size:10pt"><br><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;"><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><br><div class="gmail_quote"><br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;"><br>&nbsp;&nbsp;&nbsp; for (;
 i&lt;howmany;i++ )<br>&nbsp;&nbsp;&nbsp; {<br><br>&nbsp;&nbsp;&nbsp; sprintf (query, "INSERT INTO aaaa(a, b, c, d, e, f, g, h, j, k, l, m, n, p) VALUES (67, 'ABRAKADABRA', 'ABRAKADABRA', 'ABRAKADABRA', '1-Dec-2010', 'ABRAKADABRA', 'ABRAKADABRA',&nbsp; 'ABRAKADABRA', '1-Dec-2010', 99999, 99999, %d, 9999, 'ABRAKADABRAABRAKADABRAABRAKADABRAABRAKADABRAABRAKADABRAABRAKADABRAABRAKADABRAABRAKADABRAABRAKADABRAABRAKADABRAABRAKADABRAABRAKADABRA')", i);<br>
<br>&nbsp;&nbsp;&nbsp; res = PQexec(conn, query);<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (PQresultStatus(res) != PGRES_COMMAND_OK)<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; {<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; cout&lt;&lt;"error at iteration "&lt;&lt;i&lt;&lt;":"&lt;&lt;PQresultErrorMessage(res)&lt;&lt;endl;<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PQclear(res);<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; break;<br>&nbsp;&nbsp;&nbsp;
 &nbsp;&nbsp;&nbsp; }<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; //PQclear(res);<br><br><br>&nbsp;&nbsp;&nbsp; }<br></div></div></blockquote><div><br>&gt;Why is that PQclear(res) commented out? You're leaking result status for every insert.<br></div></div><br clear="all"><br>I did that purposely to see if cleanup part is contributing to 
any performance loss.<br>
Right now in my test, memory leak is not a concern for me but performance is. <br>
Though I understand that memory leak can also result in performance loss
 if leak is too much.<br>
However, in this case, commenting or uncommenting this statement did not
 cause any change in performance.<br><div>&nbsp;<br><br></div><br><br>
<meta http-equiv="x-dns-prefetch-control" content="on"></div></div>
</div><br>

      </body></html>
--0-573496202-1288195944=:43880--