Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 27C59636D7F
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue,  9 Mar 2010 15:23:08 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 37605-02-3
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue,  9 Mar 2010 19:22:57 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from n9.bullet.mail.ac4.yahoo.com (n9.bullet.mail.ac4.yahoo.com
	[76.13.13.237])
	by mail.postgresql.org (Postfix) with SMTP id 0527C637BCD
	for <pgsql-performance@postgresql.org>;
	Tue,  9 Mar 2010 14:44:52 -0400 (AST)
Received: from [76.13.13.26] by n9.bullet.mail.ac4.yahoo.com with NNFMP;
	09 Mar 2010 18:44:52 -0000
Received: from [67.195.9.82] by t3.bullet.mail.ac4.yahoo.com with NNFMP;
	09 Mar 2010 18:44:51 -0000
Received: from [98.137.27.216] by t2.bullet.mail.gq1.yahoo.com with NNFMP;
	09 Mar 2010 18:44:51 -0000
Received: from [127.0.0.1] by omp126.mail.gq1.yahoo.com with NNFMP;
	09 Mar 2010 18:44:51 -0000
X-Yahoo-Newman-Property: ymail-3
X-Yahoo-Newman-Id: 89657.303.bm@omp126.mail.gq1.yahoo.com
Received: (qmail 77789 invoked by uid 60001); 9 Mar 2010 18:44:50 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
	t=1268160290; bh=Sp9shKKrzqknj//RQExFRc4TP/oHe+EnEOfbbagMRSw=;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type;
	b=xauvq94UIBLXXDydXhfdXpAb/po693nadId9jU/MGc5rrZTzYepKiKOAhZO4Ym0p+MEvgb1yBRyDz0bNj81Z1bJnyaXeX+etX05kwyPNPHQH6KhraGM0RVNTyY/m4PYSFZmv1iuS6TQvG1KQJo0XVshZWzlGa7BFjxUE0fyk4HY=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type;
	b=DEPVrXEtx7+Ghvxx6WmtcLLTjfWVI0mSek8mY6syhoEaJbOFdzMVK4kVRkNX2fqP0m8KqPQUmq7ygRFgOCwqBhPQVWFxgs1x0QZ05xlxA0Wf3wRSwd7Fpg3Z95QBK7OzfA+5GfQEN47S9wXks9ET1d1Cv1PJD0fF423FsuqwpUM=;
Message-ID: <794105.77271.qm@web112509.mail.gq1.yahoo.com>
X-YMail-OSG: e4G4Yw8VM1kEcpaK8s9JhttDA0vLMIJVzR4CXPkZT.NKDQY
	MUvtoz.d17wPDbM3XtIm3tQEvSz3ORTJw_YkRHqabTHYuXGOgIQkk24BeicU
	H54XMOfpi1mECfkxriyVQ7mXlie4LyiSl2KDqRt2NFtGph_dTFySp5b86YWR
	ercCmCgoTzIg2T3MRJfcFfhpX9ss7b2NamylxYllzz95dodNGXzU1SSRhXRa
	isMib.9zAWleLNsscTDgpbVpBURqqAzOBuz7sIx2rktKzuV4DVnR0uEo1w7N
	FDPumCO2uu0TAbsxK_jiLfVi3hrn.4yENrg5TN1MNJ15PlAFE33dCB4Y-
Received: from [93.222.211.253] by web112509.mail.gq1.yahoo.com via HTTP;
	Tue, 09 Mar 2010 10:44:50 PST
X-Mailer: YahooMailClassic/9.2.12 YahooMailWebService/0.8.100.260964
Date: Tue, 9 Mar 2010 10:44:50 -0800 (PST)
From: John KEA <johnkea21@yahoo.com>
Subject: Deleting Large Objects
To: pgsql-performance@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1289976650-1268160290=:77271"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.002 tagged_above=-10 required=5
	tests=BAYES_50=0.001, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201003/96
X-Sequence-Number: 37921

--0-1289976650-1268160290=:77271
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Dear=A0PostgreSQL=A0Creators,=A0I am frequently using PostgreSQL server to =
manage the data, but I am stuck ed now with a problem of large objects dele=
ting, namely it works too slow. E.g., deleting of 900 large objects of 1 Mb=
 size takes around 2.31 minutes. This dataset is not largest one which I am=
 working with, e.g. deleting of 3000x1Mb objects takes around half an hour.=
 Could you, please, give me a few advices what do I have to do to improve t=
he deleting time? (i've tried to extend the memory server uses, but results=
 are the same)=A0Best regards!=0A=0A=0A      
--0-1289976650-1268160290=:77271
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

<table cellspacing=3D"0" cellpadding=3D"0" border=3D"0" ><tr><td valign=3D"=
top" style=3D"font: inherit;"><font class=3D"Apple-style-span" color=3D"#34=
3434" face=3D"verdana" size=3D"2"><span class=3D"Apple-style-span" style=3D=
"font-size: 10px;"><span class=3D"Apple-style-span" style=3D"color: rgb(0, =
0, 0); font-family: arial, helvetica, clean, sans-serif; font-size: 13px; b=
order-collapse: collapse; line-height: 15px; -webkit-border-horizontal-spac=
ing: 2px; -webkit-border-vertical-spacing: 2px; "><div style=3D"margin-top:=
 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top:=
 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-heig=
ht: 1.2em; outline-style: none; outline-width: initial; outline-color: init=
ial; ">Dear&nbsp;<span class=3D"yshortcuts" id=3D"lw_1268160272_0" style=3D=
"line-height: 1.2em; outline-style: none; outline-width: initial; outline-c=
olor: initial; border-bottom-style: dashed; border-bottom-width: 1px; borde=
r-bottom-color: rgb(0, 102,
 204); cursor: pointer; ">PostgreSQL</span>&nbsp;Creators,</div><div style=
=3D"margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0p=
x; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left:=
 0px; line-height: 1.2em; outline-style: none; outline-width: initial; outl=
ine-color: initial; ">&nbsp;</div><div style=3D"margin-top: 0px; margin-rig=
ht: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-ri=
ght: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 1.2em; outli=
ne-style: none; outline-width: initial; outline-color: initial; ">I am freq=
uently using PostgreSQL server to manage the data, but I am stuck ed now wi=
th a problem of large objects deleting, namely it works too slow. E.g., del=
eting of 900 large objects of 1 Mb size takes around 2.31 minutes. This dat=
aset is not largest one which I am working with, e.g. deleting of 3000x1Mb =
objects takes around half an hour. Could you, please, give me a few
 advices what do I have to do to improve the deleting time? (i've tried to =
extend the memory server uses, but results are the same)</div><div style=3D=
"margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; =
padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0p=
x; line-height: 1.2em; outline-style: none; outline-width: initial; outline=
-color: initial; ">&nbsp;</div><div style=3D"margin-top: 0px; margin-right:=
 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right=
: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 1.2em; outline-=
style: none; outline-width: initial; outline-color: initial; ">Best regards=
!</div></span></span></font></td></tr></table><br>=0A=0A      
--0-1289976650-1268160290=:77271--