Re: [GENERAL] database question

2008-09-30 Thread john . crawford
> > So the answer is you've got something that's gone hog-wild on creating > large objects and not deleting them; or maybe the application *is* > deleting them but pg_largeobject isn't getting vacuumed. > >                         regards, tom lane Hi all, thanks for the advice. I ran the script f

[GENERAL] database question

2008-09-29 Thread john . crawford
Hi all I have been experiencing some strange behaviour on my postgres DB. I am VERY new to PG so bear with me as what I am going to ask is all probably very basic to you guys. First off over the last couple of weeks we have been seeing in the dir /var/lib/pgsql/data/base/16450 some large file crea