Thanks!
Patrick Hatcher
Andrew McMillan <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/21/04 03:11 AM
To
Patrick Hatcher <[EMAIL PROTECTED]>
cc
[EMAIL PROTECTED]
Subject
Re: [PERFORM] Slow vacuum
performance
On Fri, 2004-06-18 at 19:51 -0700, Patrick H
On Fri, 2004-06-18 at 19:51 -0700, Patrick Hatcher wrote:
>
> Thanks!
>
> My effective_cache_size = 625000
>
> I thought that having the shared_buffers above 2k or 3k didn't gain
> any performance and may in fact degrade it?
Hi Patrick,
Quoting from:
http://www.varlena.com/varlena/GeneralBi
On Thu, 2004-06-17 at 13:09 -0700, Patrick Hatcher wrote:
>
>
>
> Pg: 7.4.2
> RedHat 7.3
> Ram: 8gig
>
> I have 6 million row table that I vacuum full analyze each night. The time
> seems to be streching out further and further as I add more rows. I read
> the archives and Josh's annotated p
On Thu, 17 Jun 2004, Patrick Hatcher wrote:
> I have 6 million row table that I vacuum full analyze each night. The time
> seems to be streching out further and further as I add more rows. I read
You could try to run normal (non full) vacuum every hour or so. If you do
normal vacuum often enou
scott.marlowe wrote:
> On Wed, 24 Mar 2004, pginfo wrote:
>
> > Hi,
> >
> > scott.marlowe wrote:
> >
> > > On Wed, 24 Mar 2004, pginfo wrote:
> > >
> > > > Hi,
> > > >
> > > > I am running pg 7.4.1 on linux box.
> > > > I have a midle size DB with many updates and after it I try to run
> > > > v
On Wed, 24 Mar 2004, pginfo wrote:
> Hi,
>
> scott.marlowe wrote:
>
> > On Wed, 24 Mar 2004, pginfo wrote:
> >
> > > Hi,
> > >
> > > I am running pg 7.4.1 on linux box.
> > > I have a midle size DB with many updates and after it I try to run
> > > vacuum full analyze.
> >
> > Is there a reason t
Hi,
scott.marlowe wrote:
> On Wed, 24 Mar 2004, pginfo wrote:
>
> > Hi,
> >
> > I am running pg 7.4.1 on linux box.
> > I have a midle size DB with many updates and after it I try to run
> > vacuum full analyze.
>
> Is there a reason to not use just regular vacuum / analyze (i.e. NOT
> full)?
>
On Wed, 24 Mar 2004, pginfo wrote:
> Hi,
>
> I am running pg 7.4.1 on linux box.
> I have a midle size DB with many updates and after it I try to run
> vacuum full analyze.
Is there a reason to not use just regular vacuum / analyze (i.e. NOT
full)?
> It takes about 2 h.
Full vacuums, by the
Hi Bill,
I am vacuuming every 24 h.
I have a cron script about i.
But if I make massive update (for example it affects 1 M rows) and I start vacuum,
it take this 2 h.
Also I will note, that this massive update is running in one transaction ( I can
not update 100K and start vacuum after it).
regard
pginfo wrote:
Hi,
I am running pg 7.4.1 on linux box.
I have a midle size DB with many updates and after it I try to run
vacuum full analyze.
It takes about 2 h.
If I try to dump and reload the DB it take 20 min.
How can I improve the vacuum full analyze time?
How often are you vacuuming? If you'
10 matches
Mail list logo
