------=_Part_10564_30708371.1209448017294
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Andrew,
Can you explain me in detail why u said vacuum full is making the things
worst.
We do vacuum full, as vacuum verbose analyse dont regain space for us.
~ Gauri
On Mon, Apr 28, 2008 at 9:52 PM, Andrew Sullivan <ajs@[EMAIL PROTECTED]
>
wrote:
> On Mon, Apr 28, 2008 at 07:35:37PM +0530, Gauri Kanekar wrote:
> > Peter,
> >
> > We are doing vacuum full every alternate day. We also do vacuum
analyze
> very
> > often.
>
> VACUUM FULL is making your problem worse, not better. Don't do that.
>
> > We are currently using 8.1.3 version.
>
> You need immediately to upgrade to the latest 8.1 stability and
> security release, which is 8.1.11. This is a drop-in replacement.
> It's an urgent fix for your case.
>
> > Auto vacuum is already on. But the table1 is so busy that auto vacuum
> don't
> > get sufficient chance to vacuum it :(.
>
> You probably need to tune autovacuum not to do that table, and just
> vacuum that table in a constant loop or something. VACUUM should
> _never_ "take the site down". If it does, you're doing it wrong.
>
> > Have already tried all the option listed by you, thats y we reached to
> the
> > decision of having a replication sytsem. So any suggestion on that :).
>
> I think you will find that no replication system will solve your
> underlying problems. That said, I happen to work for a company that
> will sell you a replication system to work with 8.1 if you really want
> it.
>
> A
>
>
> --
> Andrew Sullivan
> ajs@[EMAIL PROTECTED]
> +1 503 667 4564 x104
> http://www.commandprompt.com/
>
> --
> Sent via pgsql-performance mailing list
(pgsql-performance@[EMAIL PROTECTED]
)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
--
Regards
Gauri
------=_Part_10564_30708371.1209448017294
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Andrew,<br><br>Can you explain me in detail why u said vacuum full is
making the things worst.<br>We do vacuum full, as vacuum verbose analyse
dont regain space for us.<br><br>~ Gauri<br><br><div
class="gmail_quote">On Mon, Apr 28, 2008 at 9:52 PM, Andrew Sullivan
<<a href="mailto:ajs@[EMAIL PROTECTED]
">ajs@[EMAIL PROTECTED]
>>
wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204,
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div
class="Ih2E3d">On Mon, Apr 28, 2008 at 07:35:37PM +0530, Gauri Kanekar
wrote:<br>
> Peter,<br>
><br>
> We are doing vacuum full every alternate day. We also do vacuum
analyze very<br>
> often.<br>
<br>
</div>VACUUM FULL is making your problem worse, not better.
Don't do that.<br>
<div class="Ih2E3d"><br>
> We are currently using 8.1.3 version.<br>
<br>
</div>You need immediately to upgrade to the latest 8.1 stability and<br>
security release, which is <a href="http://8.1.11."
target="_blank">8.1.11.</a> This is a drop-in replacement.<br>
It's an urgent fix for your case.<br>
<div class="Ih2E3d"><br>
> Auto vacuum is already on. But the table1 is so busy that auto vacuum
don't<br>
> get sufficient chance to vacuum it :(.<br>
<br>
</div>You probably need to tune autovacuum not to do that table, and
just<br>
vacuum that table in a constant loop or something. VACUUM should<br>
_never_ "take the site down". If it does, you're doing
it wrong.<br>
<div class="Ih2E3d"><br>
> Have already tried all the option listed by you, thats y we reached
to the<br>
> decision of having a replication sytsem. So any suggestion on that
:).<br>
<br>
</div>I think you will find that no replication system will solve your<br>
underlying problems. That said, I happen to work for a company
that<br>
will sell you a replication system to work with 8.1 if you really want<br>
it.<br>
<br>
A<br>
<br>
<br>
--<br>
Andrew Sullivan<br>
<a href="mailto:ajs@[EMAIL PROTECTED]
">ajs@[EMAIL PROTECTED]
><br>
+1 503 667 4564 x104<br>
<a href="http://www.commandprompt.com/"
target="_blank">http://www.commandprompt.com/</a><br>
<font color="#888888"><br>
--<br>
Sent via pgsql-performance mailing list (<a
href="mailto:pgsql-performance@[EMAIL PROTECTED]
">pgsql-performance@[EMAIL PROTECTED]
>)<br>
To make changes to your subscription:<br>
<a href="http://www.postgresql.org/mailpref/pgsql-performance"
target="_blank">http://www.postgresql.org/mailpref/pgsql-performance</a><br>
</font></blockquote></div><br><br clear="all"><br>-- <br>Regards<br>Gauri
------=_Part_10564_30708371.1209448017294--
|
