Skip site navigation (1) Skip section navigation (2)

Re: Configuring Shared Buffers

From: "Rafael Domiciano" <rafael(dot)domiciano(at)gmail(dot)com>
To: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>
Cc: "Tino Schwarze" <postgresql(at)tisc(dot)de>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Configuring Shared Buffers
Date: 2008-06-30 23:51:05
Message-ID: 3a0028490806301651l6f3f58a3y5297ae59272b82f0@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
I have schedelus to run vacuum at the night, it starts at 01:00 AM

2008/6/30 Alvaro Herrera <alvherre(at)commandprompt(dot)com>:

> Rafael Domiciano escribió:
> > No, i don't have autovacum.
> > We tried it sometime ago, and the applications began to take "time-out".
> > I think we don't need autovacum, along the day the application don't get
> > slow, sometimes is faster (maybe the use of the applications is less).
> > The actual machine is Dual Core Xeon 1.5 and 2 Gb RAM.
>
> So how are you vacuuming your tables?
>
> --
> Alvaro Herrera
> http://www.CommandPrompt.com/
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>

In response to

Responses

pgsql-admin by date

Next:From: Alvaro HerreraDate: 2008-06-30 23:59:59
Subject: Re: Configuring Shared Buffers
Previous:From: Stephan SzaboDate: 2008-06-30 23:48:05
Subject: Re: pg_tables query issue

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group