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. ____________