SEO

Hi all,

I need some help with our database server. We have some serious
performance issues. We have PG 8.1 with 50 Million records. We have
high spec server with 8 dual core Intel Zeon with 16 gigs of ram and
we have have mysql server running on same server. All the queries take
hours to come back. We have a few indexes on table (we have only one
table). Size of our database is +100gig and its going up by 2gigs. I
don't have any insert or update since yesterday but still for some
unknown reason 2gigs were again added to file size. Here are some of
our parameters from postgres.conf. Please let me know if you want to
know any other parameters. Any help will be really appreciated.

max_connections = 100
shared_buffers = 131072
work_mem = 65536
maintenance_work_mem = 262144
max_fsm_pages = 500000
vacuum_mem = 1048576
effective_cache_size = 1500000
random_page_cost = 3.5
stats_start_collector = on
stats_command_string = on
stats_row_level = on


We also have autovacuum running

All the process take up 1Gig Virtual memeory and there could be 15
processes running at times.

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
5957 postgres 16 0 1054m 17m 16m S 0 0.1 0:01.80
postmaster
5959 postgres 16 0 9696 556 196 S 0 0.0 0:00.00
postmaster
5961 postgres 15 0 1054m 6948 6588 S 0 0.0 0:00.02
postmaster
5962 postgres 16 0 10696 1560 200 S 0 0.0 0:00.54
postmaster
5963 postgres 15 0 9832 780 272 S 0 0.0 0:00.36 postmaster