Re: selects during vacuum
От | Joe Maldonado |
---|---|
Тема | Re: selects during vacuum |
Дата | |
Msg-id | 1058382258.2420.3.camel@joem обсуждение исходный текст |
Ответ на | Re: selects during vacuum (Richard Huxton <dev@archonet.com>) |
Ответы |
Re: selects during vacuum
|
Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: