else is shared_buffers used for ?
c. Why does increasing shared_buffers to 2GB from default while leaving
wal_buffers constant at 16MB increase checkpoint buffer writes ?
tia
dushy
based on this article
(http://rhaas.blogspot.in/2012/03/tuning-sharedbuffers-and-walbuffers.html)
it looks there will be some advantages in tuning it
What would be a good value for shared_buffers and wal_buffers ?
Please let me know if additional information will help.
TIA
dushy
--
Sen
e know if additional information will help.
TIA
dushy
Hey,
There is only one autovacuum process when it starts up. Below is the
correct output from one of the logs
Good.
Do you have entries in the pg_autovacuum table in this database?
No. Its empty.
TIA
Dushyanth
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
Hey,
>> # autovacuum processes
>>
>> postgres 16508 9.2 0.1 2310836 37984 ? Ds 09:58 0:09 \_ postgres:
>> autovacuum process db1
>> postgres 19626 7.2 0.0 2289524 27704 ? Ds 10:09 0:03 \_ postgres:
>> autovacuum process db1
>> postgres 20861 7.8 0.0 2298844 31028 ?
Hey,
On Fri, Jul 4, 2008 at 10:56 PM, Adrian Klaver <[EMAIL PROTECTED]> wrote:
>
> Am forwarding back to list.
> One question? Did you do pg_ctl reload after changing the config file?
I did not change any config yet - autovacuum was always disabled since
the day PG was set up.
Thanks
Dushyanth
