How to shrink database in postgresql

From: Rehan Saleem <pk_rehan(at)yahoo(dot)com>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: How to shrink database in postgresql
Date: 2012-02-29 09:49:32
Message-ID: 1330508972.71062.YahooMailNeo@web121601.mail.ne1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

hi ,
how can i shrink database in postgresql here is a MS-SQL store procedure which shrinks the database. how same task can be achieved in postgresql.

ALTER PROCEDURE [dbo].[sp_CleanUpDB]
AS
declare @db nvarchar(50)
select @db = db_name()
DBCC SHRINKDATABASE (@db, 10)

thanks

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Pavel Stehule 2012-02-29 09:56:08 Re: How to shrink database in postgresql
Previous Message Marcin Krawczyk 2012-02-29 09:29:17 custom_variable_classes in 9.1