Postgres Pro
Downloads
Home   >   mailing lists

Re: Configuring Shared Buffers - Mailing list pgsql-admin

From Rafael Domiciano
Subject Re: Configuring Shared Buffers
Date
Msg-id 3a0028490806301651l6f3f58a3y5297ae59272b82f0@mail.gmail.com
Whole thread Raw
In response to Re: Configuring Shared Buffers  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Configuring Shared Buffers  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-admin
Tree view
I have schedelus to run vacuum at the night, it starts at 01:00 AM

2008/6/30 Alvaro Herrera <alvherre@commandprompt.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

pgsql-admin by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: pg_tables query issue
Next
From: Alvaro Herrera
Date:
Subject: Re: Configuring Shared Buffers