Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id 126C81A3BCAC
	for <pgsql-sql@postgresql.org>; Wed, 29 Feb 2012 05:49:52 -0400 (AST)
Received: from nm17-vm2.bullet.mail.ne1.yahoo.com ([98.138.91.93])
	by magus.postgresql.org with smtp (Exim 4.72)
	(envelope-from <pk_rehan@yahoo.com>) id 1S2gAN-0002q8-MU
	for pgsql-sql@postgresql.org; Wed, 29 Feb 2012 09:49:52 +0000
Received: from [98.138.90.51] by nm17.bullet.mail.ne1.yahoo.com with NNFMP;
	29 Feb 2012 09:49:32 -0000
Received: from [98.138.89.168] by tm4.bullet.mail.ne1.yahoo.com with NNFMP;
	29 Feb 2012 09:49:32 -0000
Received: from [127.0.0.1] by omp1024.mail.ne1.yahoo.com with NNFMP;
	29 Feb 2012 09:49:32 -0000
X-Yahoo-Newman-Property: ymail-3
X-Yahoo-Newman-Id: 641871.88321.bm@omp1024.mail.ne1.yahoo.com
Received: (qmail 89017 invoked by uid 60001); 29 Feb 2012 09:49:32 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
	t=1330508972; bh=u5DgfoL/D98xqCqHt2UytMTXo8DNbRGU9k5Q5drYQnQ=;
	h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type;
	b=R+OfiKchDZauwL+Nx11ux7Q+Cb6kTJqK31YxXnbfIHB1NhjqwK5zlqx2IVCFzgxRSzmsHcVTCQKRBCH2Y5nmg2Lafj/EwRw37MfXRjmRafkSVe/v0oOB77uWZCAAwDtMODE5+I2AJjtVFGbBKsXw2R2xfloRBkP40/fjTK9UQoQ=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type;
	b=Xb+tYmZNULBMukHba7oS5y3rD1Qp3wDu1DMUR2o+4PYuwyUosaiKZaSDOs7oPeYqDpQFKIvLfaaJ8yDKMEj2AR3fSIGZ4a8ZhwhqwtEkRLUZKswqBr7axx6yRg8o4hGR7chY+3zffLTmKdKC/2GE/bH995JjG1AwUkotddAModg=;
X-YMail-OSG: 2w0JN_MVM1l1NV8wFWAoh4h7BOCpSQnSm.xlzFoPESDWTZE
	2kOhLvFAnKTxCaz8MLDUoaFMZj0ZN_D2h3QLwQTpl.6m7vxdT.zGHfhR2lNf
	ZIT5TeR2JGH5vKztC3uZQNKj6ZsYzyaWtRvRghfHYCcMyEKdGk8b3GGt9ICZ
	NwpfI1AkCHBVd2d5h2LOn1Q.QDGDyLviAd55MI3CDjZBWdfeB.QlCCUoBfNV
	YudVkuxBFDya_c63Ux1DLgB1cwrqdTA9MbsoIcfxzbR6ywv5zY8N2XnMUQKw
	Oluzb_fQ1jx7Y92JoPh8doHajyzhhcSoYVe9dvl28ynRRoP6etYxaM05vSNd
	y5mPu.gEOv.QkVWpUZXdjsNFn8QkCy9f9JrZAk9FMu_56AiWeTmi58c1Kvps
	mW0ctFKREQR06Q_yMzAHy9ZORYzCVqSrgIcntqylVlHBrrIvRdSlrK8C1s96 lOWI-
Received: from [182.177.226.41] by web121601.mail.ne1.yahoo.com via HTTP;
	Wed, 29 Feb 2012 01:49:32 PST
X-Mailer: YahooMailWebService/0.8.116.338427
Message-ID: <1330508972.71062.YahooMailNeo@web121601.mail.ne1.yahoo.com>
Date: Wed, 29 Feb 2012 01:49:32 -0800 (PST)
From: Rehan Saleem <pk_rehan@yahoo.com>
Reply-To: Rehan Saleem <pk_rehan@yahoo.com>
Subject: How to shrink database in postgresql
To: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="-1977980688-308785866-1330508972=:71062"
X-Pg-Spam-Score: 1.5 (+)
X-Archive-Number: 201202/98
X-Sequence-Number: 36391

---1977980688-308785866-1330508972=:71062
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

hi ,=0Ahow can i shrink database in postgresql here is a MS-SQL store proce=
dure which shrinks the database. how same task can be=A0achieved=A0in postg=
resql.=0A=0A=0AALTER PROCEDURE [dbo].[sp_CleanUpDB]=0AAS=0Adeclare @db nvar=
char(50)=0Aselect @db =3D db_name()=0ADBCC SHRINKDATABASE (@db, 10)=0A=0Ath=
anks=0A
---1977980688-308785866-1330508972=:71062
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

<html><body><div style=3D"color:#000; background-color:#fff; font-family:ti=
mes new roman, new york, times, serif;font-size:12pt"><div style=3D"font-fa=
mily: 'times new roman', 'new york', times, serif; font-size: 12pt; ">hi ,<=
/div><div><span style=3D"font-family: 'times new roman', 'new york', times,=
 serif; font-size: 12pt;">how can i shrink database in postgresql here is a=
 MS-SQL store procedure which shrinks the database. how same task can be&nb=
sp;</span><span style=3D"font-family: 'times new roman', 'new york', times,=
 serif;">achieved</span><span style=3D"font-family: 'times new roman', 'new=
 york', times, serif; font-size: 12pt;">&nbsp;in postgresql.</span></div><d=
iv><span style=3D"font-family: 'times new roman', 'new york', times, serif;=
"><div><br></div><div>ALTER PROCEDURE [dbo].[sp_CleanUpDB]</div><div><span =
class=3D"Apple-tab-span" style=3D"white-space:pre">=09</span></div><div>AS<=
/div><div>declare @db nvarchar(50)</div><div>select @db =3D db_name()</div>=
<div>DBCC
 SHRINKDATABASE (@db, 10)</div><div><br></div><div>thanks</div></span></div=
><div style=3D"font-family: 'times new roman', 'new york', times, serif; fo=
nt-size: 12pt; "><br></div></div></body></html>
---1977980688-308785866-1330508972=:71062--