Home > mailing lists

How to shrink database in postgresql - Mailing list pgsql-sql

From	Rehan Saleem
Subject	How to shrink database in postgresql
Date	February 29, 2012 08:49:55
Msg-id	1330508972.71062.YahooMailNeo@web121601.mail.ne1.yahoo.com Whole thread Raw
Responses	Re: How to shrink database in postgresql
List	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]

declare @db nvarchar(50)

select @db = db_name()

DBCC SHRINKDATABASE (@db, 10)

thanks

From: Marcin Krawczyk
Date: 29 February 2012, 08:29:51
Subject: custom_variable_classes in 9.1

From: Pavel Stehule
Date: 29 February 2012, 08:57:02
Subject: Re: How to shrink database in postgresql