On Wednesday 16 Jul 2003 8:04 pm, Joe Maldonado wrote:
> 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 bl
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.
On Tue, Jul 15, 2003 at 04:09:28PM -0400, Joe Maldonado wrote:
> Vacuum analyze is taking a really long time on a fairly small table and
> during the time the vacuum is running all "select * from ;"
> seems to hang untill the vacuum is done. Any help on this matter would
> be greatly apprec
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 ;"
> seems to hang untill the vacuum is done. Any help on this matter would
> be greatly apprecia
Sorry forgot to mention we are running postgres 7.2.3.
-Joe
On Tue, 2003-07-15 at 16:15, scott.marlowe wrote:
> On 15 Jul 2003, 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 *
On 15 Jul 2003, 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 ;"
> seems to hang untill the vacuum is done. Any help on this matter would
> be greatly appreciated...
What ve
On Tue, Jul 15, 2003 at 04:09:28PM -0400, 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 ;"
> seems to hang untill the vacuum is done. Any help on this matter would
> be greatl
On 15 Jul 2003, 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 ;"
> seems to hang untill the vacuum is done. Any help on this matter would
> be greatly appreciated...
>
You
