From: Simon Riggs <simon@2ndquadrant.com>
To: kevin kempter <kevin@kevinkempterllc.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Join runs for > 10 hours and then fills up >1.3TB of disk space
Date: Fri, 16 May 2008 08:38:30 +0100
Message-ID: <1210923510.8820.17.camel@ebony.site> (raw)
In-Reply-To: <CEFBA6FF-0E0A-41A0-959E-7DBBDA296825@kevinkempterllc.com>
References: <CEFBA6FF-0E0A-41A0-959E-7DBBDA296825@kevinkempterllc.com>
On Fri, 2008-05-16 at 00:31 -0600, kevin kempter wrote:
> I'm running the join shown below and it takes > 10 hours and
> eventually runs out of disk space on a 1.4TB file system
Well, running in 10 hours doesn't mean there's a software problem, nor
does running out of disk space.
Please crunch some numbers before you ask, such as how much disk space
was used by the query, how big you'd expect it to be etc, plus provide
information such as what the primary key of the large table is and what
is your release level is etc..
Are you sure you want to retrieve an estimated 3 billion rows? Can you
cope if that estimate is wrong and the true figure is much higher? Do
you think the estimate is realistic?
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
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-performance@postgresql.org
Cc: simon@2ndquadrant.com, kevin@kevinkempterllc.com
Subject: Re: Join runs for > 10 hours and then fills up >1.3TB of disk space
In-Reply-To: <1210923510.8820.17.camel@ebony.site>
* 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