本文介绍了如何缩小Postgresql数据库?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

它是Event Sentry应用程序的数据库,但是由于Event Sentry只是一个监视工具,所以不要了解它如何需要这么多数据。
默认数据库文件夹中有数百个1 Gig文件。
非常感谢您提供的任何帮助!卡尔

It's the dbase for an Event Sentry Application, but since Event Sentry is just a monitoring tool, don't see how it can require this much data.There are hundreds of 1 Gig files in the default database folder.Any assistance on this one is greatly appreciated! Carl

推荐答案

在此查看名为 vacuum的操作PostgreSQL:

Take a look at this operation called 'vacuum' in PostgreSQL:

但是,在某些情况下,即使吸尘也不是解决那么多。在这种情况下,最好的办法是转储,重新创建数据库并还原它。

However, in some situations even vacuuming doesn't solve that much. In that case, the best to do is make a dump, recreate the database and restore it.

这篇关于如何缩小Postgresql数据库?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

07-26 03:39