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 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 enoug
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 t
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 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
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
בתאריך 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 n
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
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
