Joshua D. Drake wrote:
On Wed, 23 Apr 2008 16:27:33 +0100
John Gardner <[EMAIL PROTECTED]> wrote:
We have two PostgreSQL servers (8.2) running in a cluster.
Could you be a bit more specific about what you mean by: in a cluster?
Well, we're using middleware technology to load balance and clu
On Wed, Apr 23, 2008 at 9:27 AM, John Gardner <[EMAIL PROTECTED]> wrote:
> We have two PostgreSQL servers (8.2) running in a cluster.
>
> We have autovacuum switched on on both servers and also we are running the
> following as a cron job;
>
> Server 1:
> 30 0,2,4,6,8,10,12,14,16,18,20,22 * * *
On Wed, 23 Apr 2008 16:27:33 +0100
John Gardner <[EMAIL PROTECTED]> wrote:
> We have two PostgreSQL servers (8.2) running in a cluster.
Could you be a bit more specific about what you mean by: in a cluster?
> Now, we're not seeing any problems with performance and we're not
> seeing any bloat bu
We have two PostgreSQL servers (8.2) running in a cluster.
We have autovacuum switched on on both servers and also we are running
the following as a cron job;
Server 1:
30 0,2,4,6,8,10,12,14,16,18,20,22 * * * /usr/bin/vacuumdb --all --analyze
Server 2:
30 1,3,5,7,9,11,13,15,17,19,21,23 * * *
Matthew T. O'Connor wrote:
Richard Huxton wrote:
Joe Maldonado wrote:
Hello all,
I have a few somewhat simple questions
Does the postmaster vacuum it's internal (pg_*) tables? if not
what is the best way to vacuum them without having to vacuum the
entire db?
and how often is this recomme
Richard Huxton wrote:
Joe Maldonado wrote:
Hello all,
I have a few somewhat simple questions
Does the postmaster vacuum it's internal (pg_*) tables? if not
what is the best way to vacuum them without having to vacuum the
entire db?
and how often is this recommended to be done?
No, and I
Joe Maldonado wrote:
Hello all,
I have a few somewhat simple questions
Does the postmaster vacuum it's internal (pg_*) tables? if not
what is the best way to vacuum them without having to vacuum the
entire db?
and how often is this recommended to be done?
No, and I'd vacuum full template
Hello all,
I have a few somewhat simple questions
Does the postmaster vacuum it's internal (pg_*) tables?
if not
what is the best way to vacuum them without having to vacuum the
entire db?
and how often is this recommended to be done?
Thanks,
-Joe
---(end of bro
