Skip site navigation (1) Skip section navigation (2)

RES: Degradation of postgres 7.4.5 on FreeBSD/CygWin

From: "Rodrigo Moreno" <rodrigo(dot)miguel(at)terra(dot)com(dot)br>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: RES: Degradation of postgres 7.4.5 on FreeBSD/CygWin
Date: 2005-02-18 15:43:58
Message-ID: KMEJIOKLKEBIECAIJKPKMENOCAAA.rodrigo.miguel@terra.com.br (view raw or flat)
Thread:
Lists: pgsql-performance
Hi,

this is only max 15 concurrent conections. And is not a heavy performance
database, so i think this is not necessary vacumm more than once a day.

In another customer, has only 5 users and the database have 300mb, small
database, and has the same behaviour (haven't modified postgresql).
My first instalation was not changed anything in postgresql.conf, but in
this new server (FreeBSD) i have changed some parameters.

as showed in my crontab list, i think this is enough:
00 13 * * 1-5 /bin/sh /home/postgres/backup.sh >/dev/null 2>&1
00 19 * * 1-5 /bin/sh /home/postgres/backup.sh >/dev/null 2>&1
00 23 * * 1-5 /usr/local/pgsql/bin/psql supre -c "vacuum analyze;"
>>/dev/null 2>&1
00 23 * * 6 /usr/local/pgsql/bin/psql supre -c "reindex database supre;"
>>/dev/null 2>&1
00 23 * * 7 /usr/local/pgsql/bin/psql supre -c "vacuum full analyze;"
>>/dev/null 2>&1

These my changed configs in postgresql.conf:
max_connections = 30
shared_buffers = 8192
sort_mem = 32768
vacuum_mem = 32768
max_fsm_pages = 40000
max_fsm_relations = 2000

But why after 2 months the database has 1.3gb and after reimport on 900mb ?

Both customer are smaller databases, but one of them, has 8 years os data,
it's the reason of size 900mb, these are too smaller database.

Regards
Rodrigo Moreno


In response to

Responses

pgsql-performance by date

Next:From: Rodrigo MorenoDate: 2005-02-18 16:10:01
Subject: RES: RES: Degradation of postgres 7.4.5 on FreeBSD/CygWin
Previous:From: Merlin MoncureDate: 2005-02-18 15:11:18
Subject: Re: win32 performance - fsync question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group