Re: selects during vacuum

Here it is...
things to note:
    This table contains 1 record allways.
    The record is updated once per second.
    Every 167 seconds a vacuum analyze is run on the table
    After some time it hangs in the analyze and blocks all
     access to that table including selects.


# vacuum analyze verbose <table_name>
# ;
NOTICE:  --Relation <table_name>--
NOTICE:  Pages 513: Changed 1, Empty 0; Tup 80: Vac 0, Keep 79, UnUsed 4540.
        Total CPU 0.02s/0.00u sec elapsed 0.02 sec.
NOTICE:  --Relation pg_toast_18119--
NOTICE:  Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Analyzing <table_name>

We dropped the table and recreated it and things have seemed to be
working right for now though I have an accelerated simulation of the
conditions running on another db to see if we can reproduce...

-Joe

On Tue, 2003-07-15 at 16:35, Richard Huxton wrote:
> On Tuesday 15 Jul 2003 9:09 pm, Joe Maldonado wrote:
> > Hello,
> >     Vacuum analyze is taking a really long time on a fairly small table and
> > during the time the vacuum is running all "select * from <the table>;"
> > seems to hang untill the vacuum is done.  Any help on this matter would
> > be greatly appreciated...
>
> Can you post the output of a "verbose" vacuum analyse? That will tell us what
> it's up to.