Re: When adding millions of rows at once, getting out of disk space errors

From: Mike Christensen <imaudi(at)comcast(dot)net>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: When adding millions of rows at once, getting out of disk space errors
Date: 2009-02-19 18:34:05
Message-ID: 499DA61D.3070108@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Yea sorry good point.. It's probably at least safe to say the process
should not just hang though, and there should be more info in the log as
to what it's doing..

John R Pierce wrote:
> Mike Christensen wrote:
>> First off, when Postgres starts and sees that your database was not
>> closed properly, it should tell you there's pending transactions and
>> ask if you want to dump them or try to process them (or maybe save
>> them for later). If you process them, there should be clear status
>> and you should know what's going on.
>
>
> how does a system service ask you anything? a service normally
> starts when the system boots, before anyone logs onto the console.
>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Erik Jones 2009-02-19 18:40:12 Re: Appending \o output instead of overwriting the output file
Previous Message Erik Jones 2009-02-19 18:31:49 Re: How to pipe the psql copy command to Unix 'Date' command