autovacuum configuration

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello:
I have been trying to improve the performance of my 8.3.3 postgres
database, running on solaris 10. I have been playing around with a few
configuration settings, including the shared_buffers because I have
sluggish performance when accessing some very large tables, and the
maintence_work_mem because my database is showing signs of bloat.
What I'm not sure about is how to measure the success of these
configuration changes. In order to test the change in shared_buffers, I
tried running pg_bench and explain analyze on some slow queries but
there is quite a bit of variation in these metrics. I can check the size
of some of the tables that have shown bloat, but that is fairly slow
feedback. Are there better metrics to check these config changes?
Thanks in advance!
Mija

CONFIDENTIALITY NOTICE: This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain
confidential, proprietary, and/or privileged information protected by
law. If you are not the intended recipient, you may not use, copy, or
distribute this e-mail message or its attachments. If you believe you
have received this e-mail message in error, please contact the sender by
reply e-mail and destroy all copies of the original message.


-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux