pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedn00b autovacuum question
6+ messages / 3 participants
[nested] [flat]
* n00b autovacuum question
@ 2006-03-18 12:01 Antoine <melser.anton@gmail.com>
2006-03-18 15:54 ` Re: n00b autovacuum question Matthew T. O'Connor <matthew@zeut.net>
2006-03-18 17:46 ` Re: n00b autovacuum question Andreas Pflug <pgadmin@pse-consulting.de>
0 siblings, 2 replies; 6+ messages in thread
From: Antoine @ 2006-03-18 12:01 UTC (permalink / raw)
To: pgsql-performance
Hi,
I have enabled the autovacuum daemon, but occasionally still get a
message telling me I need to run vacuum when I access a table in
pgadmin. Is this normal? Should I use scripts instead of the daemon?
Would posting config options make this a much more sensible question?
Cheers
Antoine
--
This is where I should put some witty comment.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: n00b autovacuum question
2006-03-18 12:01 n00b autovacuum question Antoine <melser.anton@gmail.com>
@ 2006-03-18 15:54 ` Matthew T. O'Connor <matthew@zeut.net>
1 sibling, 0 replies; 6+ messages in thread
From: Matthew T. O'Connor @ 2006-03-18 15:54 UTC (permalink / raw)
To: Antoine <melser.anton@gmail.com>; +Cc: pgsql-performance
More detail please. It sounds like you running 8.1 and talking about
the integrated autovacuum is that correct? Also, what is the message
specifically from pgadmin?
Matt
Antoine wrote:
> Hi,
> I have enabled the autovacuum daemon, but occasionally still get a
> message telling me I need to run vacuum when I access a table in
> pgadmin. Is this normal? Should I use scripts instead of the daemon?
> Would posting config options make this a much more sensible question?
> Cheers
> Antoine
>
> --
> This is where I should put some witty comment.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: n00b autovacuum question
2006-03-18 12:01 n00b autovacuum question Antoine <melser.anton@gmail.com>
@ 2006-03-18 17:46 ` Andreas Pflug <pgadmin@pse-consulting.de>
2006-03-19 12:27 ` Re: n00b autovacuum question Antoine <melser.anton@gmail.com>
1 sibling, 1 reply; 6+ messages in thread
From: Andreas Pflug @ 2006-03-18 17:46 UTC (permalink / raw)
To: Antoine <melser.anton@gmail.com>; +Cc: pgsql-performance
Antoine wrote:
> Hi,
> I have enabled the autovacuum daemon, but occasionally still get a
> message telling me I need to run vacuum when I access a table in
> pgadmin.
pgAdmin notices a discrepancy between real rowcount and estimated
rowcount and thus suggests to run vacuum/analyze; it won't examine
autovacuum rules so it might warn although autovac is running ok.
If you're sure autovacuum is running fine, just dismiss the message.
It's a hint for newbies that do *not* run vacuum because they don't know
what it's good for.
Regards
Andreas
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: n00b autovacuum question
2006-03-18 12:01 n00b autovacuum question Antoine <melser.anton@gmail.com>
2006-03-18 17:46 ` Re: n00b autovacuum question Andreas Pflug <pgadmin@pse-consulting.de>
@ 2006-03-19 12:27 ` Antoine <melser.anton@gmail.com>
2006-03-19 14:47 ` Re: n00b autovacuum question Andreas Pflug <pgadmin@pse-consulting.de>
0 siblings, 1 reply; 6+ messages in thread
From: Antoine @ 2006-03-19 12:27 UTC (permalink / raw)
To: Andreas Pflug <pgadmin@pse-consulting.de>; +Cc: pgsql-performance
On 18/03/06, Andreas Pflug <pgadmin@pse-consulting.de> wrote:
> Antoine wrote:
> > Hi,
> > I have enabled the autovacuum daemon, but occasionally still get a
> > message telling me I need to run vacuum when I access a table in
> > pgadmin.
>
> pgAdmin notices a discrepancy between real rowcount and estimated
> rowcount and thus suggests to run vacuum/analyze; it won't examine
> autovacuum rules so it might warn although autovac is running ok.
>
> If you're sure autovacuum is running fine, just dismiss the message.
I guess that is my problem - I a not sure it is running fine. The
process is definitely running but I am getting lots of complaints
about performance. This probably has lots to do with crap code and not
much to do with the database but I am still searching the maintenance
avenue... We have a massive project coming up and I want to go for
Postgres (the boss wants Oracle). If I can't get my stuff together I
am not sure my arguments will stick... problem is I don't really have
the time to experiment properly.
Cheers
Antoine
--
This is where I should put some witty comment.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: n00b autovacuum question
2006-03-18 12:01 n00b autovacuum question Antoine <melser.anton@gmail.com>
2006-03-18 17:46 ` Re: n00b autovacuum question Andreas Pflug <pgadmin@pse-consulting.de>
2006-03-19 12:27 ` Re: n00b autovacuum question Antoine <melser.anton@gmail.com>
@ 2006-03-19 14:47 ` Andreas Pflug <pgadmin@pse-consulting.de>
2006-03-19 15:34 ` Re: n00b autovacuum question Antoine <melser.anton@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Andreas Pflug @ 2006-03-19 14:47 UTC (permalink / raw)
To: Antoine <melser.anton@gmail.com>; +Cc: pgsql-performance
Antoine wrote:
> On 18/03/06, Andreas Pflug <pgadmin@pse-consulting.de> wrote:
>
>>Antoine wrote:
>>
>>>Hi,
>>>I have enabled the autovacuum daemon, but occasionally still get a
>>>message telling me I need to run vacuum when I access a table in
>>>pgadmin.
Bring up the postgresql.conf editor on that server, and watch if pgadmin
complains.
Regards,
Andreas
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: n00b autovacuum question
2006-03-18 12:01 n00b autovacuum question Antoine <melser.anton@gmail.com>
2006-03-18 17:46 ` Re: n00b autovacuum question Andreas Pflug <pgadmin@pse-consulting.de>
2006-03-19 12:27 ` Re: n00b autovacuum question Antoine <melser.anton@gmail.com>
2006-03-19 14:47 ` Re: n00b autovacuum question Andreas Pflug <pgadmin@pse-consulting.de>
@ 2006-03-19 15:34 ` Antoine <melser.anton@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Antoine @ 2006-03-19 15:34 UTC (permalink / raw)
To: Andreas Pflug <pgadmin@pse-consulting.de>; +Cc: pgsql-performance
On 19/03/06, Andreas Pflug <pgadmin@pse-consulting.de> wrote:
> Antoine wrote:
> > On 18/03/06, Andreas Pflug <pgadmin@pse-consulting.de> wrote:
> >
> >>Antoine wrote:
> >>
> >>>Hi,
> >>>I have enabled the autovacuum daemon, but occasionally still get a
> >>>message telling me I need to run vacuum when I access a table in
> >>>pgadmin.
>
> Bring up the postgresql.conf editor on that server, and watch if pgadmin
> complains.
Hi,
I am not sure I understand what "bring up" means. Could you explain?
Thanks
Antoine
--
This is where I should put some witty comment.
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2006-03-19 15:34 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-03-18 12:01 n00b autovacuum question Antoine <melser.anton@gmail.com>
2006-03-18 15:54 ` Matthew T. O'Connor <matthew@zeut.net>
2006-03-18 17:46 ` Andreas Pflug <pgadmin@pse-consulting.de>
2006-03-19 12:27 ` Antoine <melser.anton@gmail.com>
2006-03-19 14:47 ` Andreas Pflug <pgadmin@pse-consulting.de>
2006-03-19 15:34 ` Antoine <melser.anton@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox