Hello,
We will be consolidating from 4 databases to 2 and want to make sure that
these parameters are the only ones that need changing. Please advise.
Current Future
= =
Ma
Barbara Stephenson writes:
> We will be consolidating from 4 databases to 2 and want to make sure that
> these parameters are the only ones that need changing. Please advise.
> Current Future
> =
Thank ypu!
Tom Lane wrote:
Barbara Stephenson writes:
We will be consolidating from 4 databases to 2 and want to make sure that
these parameters are the only ones that need changing. Please advise.
Current Future
=
pgsql-admin@postgresql.org
Subject: Re: [ADMIN] tuning our database by increasing shared buffer
Thank ypu!
Tom Lane wrote:
Barbara Stephenson
<mailto:barb...@turbocorp.com> writes:
We will be consolidating from 4 databases to 2 and want to make
sure that
these parameters
Run a vacuum verbose and look at the output at the end.
Word is that as of 8.4 these parameters will autotune themselvs.
--- On Wed, 24/6/09, Allgood, John wrote:
> From: Allgood, John
> Subject: Re: [ADMIN] tuning our database by increasing shared buffer
> To: "Barbara Step
jallg...@ohl.com
www.ohl.com
-Original Message-
From: Glyn Astill [mailto:glynast...@yahoo.co.uk]
Sent: Wednesday, June 24, 2009 9:46 AM
To: Barbara Stephenson; Tom Lane; Allgood, John
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] tuning our database by increasing shared buffer
Run a
"Allgood, John" wrote:
> What exactly am I looking for
> INFO: free space map contains 2667 pages in 22 relations
> DETAIL: A total of 3008 page slots are in use (including overhead).
> 3008 page slots are required to track all free space.
> Current limits are: 153600 page slots, 1000 relat