On 30 Jan 2011, at 17:14, Herouth Maoz wrote:
On 30/01/2011, at 12:27, Craig Ringer wrote:
OK, so you're pre-8.4 , which means you have the max_fsm settings to play
with. Have you seen any messages in the logs about the free space map (fsm)?
If your install didn't have a big enough fsm to
On 31/01/2011, at 03:49, Craig Ringer wrote:
For approaches to possibly fixing your problem, see:
http://www.depesz.com/index.php/2010/10/17/reduce-bloat-of-table-without-longexclusive-locks/
http://blog.endpoint.com/2010/09/reducing-bloat-without-locking.html
I'm not quite sure what
On 30/01/2011, at 13:03, Alban Hertroys wrote:
On 28 Jan 2011, at 22:12, Herouth Maoz wrote:
2. That database has a few really huge tables. I think they are not being
automatically vacuumed properly. In the past few days I've noticed a vacuum
process on one of them which has been running
On Sun, Jan 30, 2011 at 04:56:29PM +0200, Herouth Maoz wrote:
Unless my eyes were deceiving me, this was not the case. Sure, there have
been heavy transactions during that time (e.g. the daily backup of the
database, and the daily inserts into other tables, which take a long time,
and a
On 30/01/2011, at 12:27, Craig Ringer wrote:
OK, so you're pre-8.4 , which means you have the max_fsm settings to play
with. Have you seen any messages in the logs about the free space map (fsm)?
If your install didn't have a big enough fsm to keep track of deleted tuples,
you'd face
On 01/31/2011 12:14 AM, Herouth Maoz wrote:
On 30/01/2011, at 12:27, Craig Ringer wrote:
OK, so you're pre-8.4 , which means you have the max_fsm settings to
play with. Have you seen any messages in the logs about the free space
map (fsm)? If your install didn't have a big enough fsm to keep
On 01/29/2011 05:12 AM, Herouth Maoz wrote:
The machine has no additional room for internal disks. It is a recent
purchase and not likely to be replaced any time soon.
Newly acquired or not, it sounds like it isn't sized correctly for the
load and needs an upgrade if it can't be shifted into
בתאריך 29/01/11 13:57, ציטוט Craig Ringer:
On 01/29/2011 05:12 AM, Herouth Maoz wrote:
The machine has no additional room for internal disks. It is a recent
purchase and not likely to be replaced any time soon.
Newly acquired or not, it sounds like it isn't sized correctly for the
load and
Hello. We have two problems (which may actually be related...)
1. We are running at over 90% capacity of the disk at one of the servers - a
report/data warehouse system. We have ran out of disk space several times. Now
we need to make some file-archived data available on the database to support
