Bacula-users

Re: [Bacula-users] PG Insert NEVER stops

2009-04-09 01:13:37
Subject: Re: [Bacula-users] PG Insert NEVER stops
From: Craig Ringer <craig AT postnewspapers.com DOT au>
To: Dan Langille <dan AT langille DOT org>
Date: Thu, 09 Apr 2009 13:09:32 +0800
Dan Langille wrote:
> mehma sarja wrote:
>> PROBLEM - I have run multiple fulls and have NEVER been able to complete
>> a PG insert operation. Granted my fileset is large - about 9.8 million
>> files, ~700GB. What am I doing wrong?
> 
> Well, you've not told us much.  What happens when you run the job?
> Perhaps the job output would help.

What would *REALLY* help would be the output of EXPLAIN run on the query
that never stops. You'd need to do that from the Pg console. I posted
instructions for someone else with a similar issue earlier.

--
Craig Ringer

------------------------------------------------------------------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users

<Prev in Thread] Current Thread [Next in Thread>