Re: RES: [GENERAL] Problem with evergrowing files - Mailing list pgsql-general

From Dustin Sallings
Subject Re: RES: [GENERAL] Problem with evergrowing files
Date
Msg-id Pine.SGI.3.95.990226155456.24543C-100000@bleu.west.spy.net
Whole thread Raw
In response to RES: [GENERAL] Problem with evergrowing files  ("Ricardo J.C.Coelho" <pulsar@truenet-ce.com.br>)
List pgsql-general
On Fri, 26 Feb 1999, Ricardo J.C.Coelho wrote:

    I might add, do that every day.  :)

    I run vacuum analyze; on every database every night as part of my
backup scripts.

# Hi,
#
# Run:
#
# psql> vacuum table_name;
#
#
#
# ----- Mensagem original -----
# De:        M Simms [SMTP:grim@argh.demon.co.uk]
# Enviada em:        Sexta-feira, 26 de Fevereiro de 1999 18:29
# Para:        pgsql-general@postgreSQL.org
# Assunto:        [GENERAL] Problem with evergrowing files
#
# Hi
#
# I have a BIG problem with a database.
#
# The database is only around 500 records. It gets updated, every record,
# once an hour. When I started up the database about 2 weeks ago, it was all
# good, and did all the updates in about 3 minutes (it is purely a series of
# updates, nothing complex).
#
# I noticed recently that the updates were taking longer. In fact they are now
# taking over half an hour. This is crazy on a 300MHz machine with 160 MB of
# memory.
#
# I checked the database, and the file containing these 400 records is *HUGE*
# It is around 50 Megs in size.
# When I run select * into recordbak from record; from psql, it creates a new
# file in the database directory, and this file is around 200K, less than 0.5%
# of the size!!!
#
# I am running postgresql 6.3.2 (I know it is slightly old, but when I updated
# to a newer version, but it started to spawn dozens of copies, and took the
# load of my server up to over 100, so I reverted back to what was working.
# Sorry I cant provide much more of a bug report there but I run a business
# application and I cant afford to have it killing my machine to get a
# bug report)
#
# But I need to know WHY it has increased its size by over 200 times the
# size of the database...
#
# My machine is again being hammered, to do this simple set of updates
# takes it 34 minutes in every hour taking up 90% CPU on a decent sized
# server!
#
# Any suggestions? Or is this a known problem? And is there any fix?
#
# Thanks
#
#                     M Simms
#
#
#

--
SA, beyond.com           My girlfriend asked me which one I like better.
pub  1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net>
|    Key fingerprint =  87 02 57 08 02 D0 DA D6  C8 0F 3E 65 51 98 D8 BE
L_______________________ I hope the answer won't upset her. ____________


pgsql-general by date:

Previous
From: "Robert Chalmers"
Date:
Subject: Re: [GENERAL] Q's: discussion group; pgsql authorization
Next
From: M Simms
Date:
Subject: Thanks