Scott Marlowe a écrit :
> On 10/17/07, Stéphane Schildknecht
> <[EMAIL PROTECTED]> wrote:
>
>> Tom Lane a écrit :
>>
>> Yes, I am. The command line is (in a shell script whom ouput is
>> redirected in a global file) :
>>
>> vacuumdb -d $DBNAME -p $DBPORT -U $DBUSR -z -v
>>
>>
>> That does not ex
Tom Lane a écrit :
> =?ISO-8859-1?Q?St=E9phane_Schildknecht?= <[EMAIL PROTECTED]> writes:
>
>> Yes, I am. The command line is (in a shell script whom ouput is
>> redirected in a global file) :
>>
>
>
>> vacuumdb -d $DBNAME -p $DBPORT -U $DBUSR -z -v
>>
>
>
>> That does not expl
On 10/17/07, Stéphane Schildknecht
<[EMAIL PROTECTED]> wrote:
> Tom Lane a écrit :
>
> Yes, I am. The command line is (in a shell script whom ouput is
> redirected in a global file) :
>
> vacuumdb -d $DBNAME -p $DBPORT -U $DBUSR -z -v
>
>
> That does not explain why we don't get FSM statitics displ
Stefano Dal Pra escribió:
> Your first post says vacuum goes worse (slower).
> I see that you do not issue the -f option (FULL VACUUM).
>
> I had a similar situation with a server (with frequent update)
> performing nightly vacuumdb. After a few many days it went
> slower and slower.
When you hav
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> What would be really useful is to remove all that noise from vacuum and
> make it appear on a view.
Well, if you want something decoupled from VACUUM there's already
contrib/pg_freespacemap.
> 8.4 material all of this, of course.
I am hoping that we r
=?ISO-8859-1?Q?St=E9phane_Schildknecht?= <[EMAIL PROTECTED]> writes:
> Yes, I am. The command line is (in a shell script whom ouput is
> redirected in a global file) :
> vacuumdb -d $DBNAME -p $DBPORT -U $DBUSR -z -v
> That does not explain why we don't get FSM statitics display.
Is $DBUSR a su
Your first post says vacuum goes worse (slower).
I see that you do not issue the -f option (FULL VACUUM).
I had a similar situation with a server (with frequent update)
performing nightly vacuumdb. After a few many days it went
slower and slower.
The first solution was to add the -f switch.
Note
Joshua D. Drake wrote:
> On Tue, 16 Oct 2007 17:03:39 -0700 (PDT)
> Brian Herlihy <[EMAIL PROTECTED]> wrote:
>
> > Would it make sense to show the FSM stats for individual table
> > vaccums as well? I'm wondering if the reason they aren't shown is
> > because it wouldn't be useful or isn't practi
Tom Lane a écrit :
> "Scott Marlowe" <[EMAIL PROTECTED]> writes:
>
>> On 10/16/07, St=E9phane Schildknecht
>> <[EMAIL PROTECTED]> wrote:
>>
>>> That's also why I am so disappointed vacuum doesn't give me these 4
>>> hints lines.
>>>
>
>
>> What kind of error, or output, does it gi
On Tue, 16 Oct 2007 17:03:39 -0700 (PDT)
Brian Herlihy <[EMAIL PROTECTED]> wrote:
> Would it make sense to show the FSM stats for individual table
> vaccums as well? I'm wondering if the reason they aren't shown is
> because it wouldn't be useful or isn't practical, or just that it
> hasn't been
Brian Herlihy <[EMAIL PROTECTED]> writes:
> Would it make sense to show the FSM stats for individual table vaccums as w=
> ell? I'm wondering if the reason they aren't shown is because it wouldn't =
> be useful or isn't practical, or just that it hasn't been done.
It was intentionally omitted in
Would it make sense to show the FSM stats for individual table vaccums as well?
I'm wondering if the reason they aren't shown is because it wouldn't be useful
or isn't practical, or just that it hasn't been done.
Brian
- Original Message
From: Tom Lane <[EMAIL PROTECTED]>
If you're t
"Scott Marlowe" <[EMAIL PROTECTED]> writes:
> On 10/16/07, St=E9phane Schildknecht
> <[EMAIL PROTECTED]> wrote:
>> That's also why I am so disappointed vacuum doesn't give me these 4
>> hints lines.
> What kind of error, or output, does it give you at the end? Any hint
> as to why they're missing
On 10/16/07, Stéphane Schildknecht
<[EMAIL PROTECTED]> wrote:
> Tom Lane a écrit :
> > =?ISO-8859-1?Q?St=E9phane_Schildknecht?= <[EMAIL PROTECTED]> writes:
> >
> >> For some times, we have a vacuuming process on a specific table that
> >> goes slower and slower. In fact, it took some 3 minutes a mo
=?ISO-8859-1?Q?St=E9phane_Schildknecht?= <[EMAIL PROTECTED]> writes:
> Tom Lane a écrit :
>> The real question is how often do rows get updated? I suspect you
>> probably need to vacuum this table more than once a day.
> To be honest, I suspect it too. But, I have been told by people using
> that
Tom Lane a écrit :
> =?ISO-8859-1?Q?St=E9phane_Schildknecht?= <[EMAIL PROTECTED]> writes:
>
>> For some times, we have a vacuuming process on a specific table that
>> goes slower and slower. In fact, it took some 3 minutes a month ago, and
>> now it take almost 20 minutes. But, if one day it tak
=?ISO-8859-1?Q?St=E9phane_Schildknecht?= <[EMAIL PROTECTED]> writes:
> For some times, we have a vacuuming process on a specific table that
> goes slower and slower. In fact, it took some 3 minutes a month ago, and
> now it take almost 20 minutes. But, if one day it take so many time, it
> is possi
Heikki Linnakangas a écrit :
> Stéphane Schildknecht wrote:
>
>> I wonder vacuum verbose would tell me if fsm parameters were not too
>> badly configured, but I can't get the 4 last lines of the output...
>>
>
> Why not?
>
I would like to know... Seems like vacuum does not want me to se
Stéphane Schildknecht wrote:
> I wonder vacuum verbose would tell me if fsm parameters were not too
> badly configured, but I can't get the 4 last lines of the output...
Why not?
> Whats's more, I wonder what we could monitor to get some explanation of
> the recent time increase, and then have a
19 matches
Mail list logo
