On Jul 14, 2007, at 11:50 AM, Patric de Waha wrote:
Yesterday I switched from 8.1 to 8.2. So I needed to dump the
dbase
and reimport it. The dbase after 4 months of running without
"vacuum full"
reached 60 gigabyte of diskspace. Now after a fresh import it
only has 5 gigabyte!
Joshua D. Drake a écrit :
No wonder, I got IO problems with such a fragmentation.
For people not very familiar with postgres especially those coming
from mysql,
i'd recommend paying attention to this.
Definitely. The problem here is that you just aren't vacuuming enough,
not that
Patric de Waha <[EMAIL PROTECTED]> writes:
> Yesterday I switched from 8.1 to 8.2. So I needed to dump the dbase
> and reimport it. The dbase after 4 months of running without "vacuum
> full"
> reached 60 gigabyte of diskspace. Now after a fresh import it only
> has 5 gigabyte!
>
No wonder, I got IO problems with such a fragmentation.
For people not very familiar with postgres especially those coming
from mysql,
i'd recommend paying attention to this.
Definitely. The problem here is that you just aren't vacuuming enough,
not that you didn't vacuum full. I
Hi,
Something I'd like to share.
I switched to postgres about 4 months ago.
The perfomance after a while got worse.
I posted a message here, where the result was that my IO was the
problem.
I run vacuum every night. I never used vacuum full because it is not
explicitly reco
Gregory Stark wrote:
>> From the DELL site it seems this `PERC 5/i' on board controller
>> (assuming that's what you have) doesn't even have a BBU. If you don't
>> plan to post here in a few weeks again about data corruption, go out and
>> shop a serious controller.
>
> This is a bit of a strange
"Hannes Dorbath" <[EMAIL PROTECTED]> writes:
> From the DELL site it seems this `PERC 5/i' on board controller
> (assuming that's what you have) doesn't even have a BBU. If you don't
> plan to post here in a few weeks again about data corruption, go out and
> shop a serious controller.
This is a
On Sat, Jul 14, 2007 at 10:29:05AM +0200, Hannes Dorbath wrote:
> From the DELL site it seems this `PERC 5/i' on board controller
> (assuming that's what you have) doesn't even have a BBU. If you don't
> plan to post here in a few weeks again about data corruption, go out and
> shop a serious contr
Joseph wrote:
> We just got a DELL POWEREDGE 2950. So I was tasked with putting
> Linux Redhat and dumped our software/packages on it. Contrary to
> common sense, I didn't bother reading the manuals that came with te
> 2950. I went right ahead and installed Redhat server on it, then went
> and
