Re: Index size growing

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

 



Hi,

Pls find the below output of the query given in the below link.

             name             |                                           current_setting                                    
------------------------------+-----------------------------------------------------------------------------------------------------
 version                      | PostgreSQL 8.3.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20070115 (SUSE Linux)
 archive_command              | /var/lib/pgsql/bin/cmd_archiver -A -C /var/lib/pgsql/etc/cmd_archiver.ini -F %p
 archive_mode                 | on
 checkpoint_completion_target | 0.7
 checkpoint_segments          | 10
 checkpoint_timeout           | 15min
 default_statistics_target    | 100
 effective_cache_size         | 1328MB
 lc_collate                   | en_GB.UTF-8
 lc_ctype                     | en_GB.UTF-8
 listen_addresses             | *
 log_destination              | stderr
 log_filename                 | postgresql-%Y-%m-%d.log
 log_line_prefix              | %t %d %u
 log_min_duration_statement   | 5s
 log_rotation_size            | 0
 logging_collector            | on
 maintenance_work_mem         | 256MB
 max_connections              | 250
 max_fsm_pages                | 2048000
 max_stack_depth              | 2MB
 server_encoding              | UTF8
 shared_buffers               | 768MB
 silent_mode                  | on
 TimeZone                     | Europe/Brussels
 work_mem                     | 2MB


Prasad

On Fri, Apr 1, 2011 at 8:23 PM, Kevin Grittner <Kevin.Grittner@xxxxxxxxxxxx> wrote:
Rajendra prasad <rajendra.dn@xxxxxxxxx> wrote:

> I am not doing vacuum atall.

Please run the query on this page and post the results:

http://wiki.postgresql.org/wiki/Server_Configuration

My hope is that you are on a recent version of PostgreSQL with
autovacuum taking care of things by default.

-Kevin


[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