pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Darren Reed <darrenr+postgres@fastmail.net>
To: Joshua D. Drake <jd@commandprompt.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Is my database now too big?
Date: Sun, 07 Oct 2007 10:00:07 +0200
Message-ID: <1191744007.14918.1214548241@webmail.messagingengine.com> (raw)
In-Reply-To: <47087723.7040403@commandprompt.com>
References: <1191730382.18880.1214536197@webmail.messagingengine.com>
	<47087723.7040403@commandprompt.com>

On Sat, 06 Oct 2007 23:05:23 -0700, "Joshua D. Drake"
<jd@commandprompt.com> said:
> Darren Reed wrote:
> > I'm starting to wonder if my database has finally grown too big for my
> > computer.
> > 
> > But, rather than peform badly, I see a number of "bad things" happen:
> > 
> > * pg_dump fails to run, causing an "out of memory" error (I don't
> > understand
> >   why this happens, but it does);
> > 
> > * restarting postgres across a reboot results in tables disappearing
> >   without any error messages being given out (this is *really
> >   disturbing*.)
> 
> Are you vacuuming?

No.  I'm just using the standard config

If you're implying I should?

The problems I've come across have become evident with as little work as
this:
- run "initdb"
- start postgres
- run "psql" to import the dumped data
- run for a short period of time (less than an hour)
- shutdown postgres
- reboot
- postgres starts
- the large tables are now missing

With the above, I wouldn't have thought there is enough time to do
vacuums,
which seem to take quite a while on large tables.  The activity is a
mixture
of inserts and updates (from triggers and plsql functions.)

Darren



view thread (27+ messages)  latest in thread

Message-ID: <1191744007.14918.1214548241@webmail.messagingengine.com>
Permalink:  ../1191744007.14918.1214548241@webmail.messagingengine.com/
Also on:    postgresql.org/message-id/1191744007.14918.1214548241@webmail.messagingengine.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: darrenr+postgres@fastmail.net, jd@commandprompt.com
  Subject: Re: Is my database now too big?
  In-Reply-To: <1191744007.14918.1214548241@webmail.messagingengine.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox