> This query takes a totally unrealistic amount of time for execution (I have it running for >30 minutes now on a machine with 8GB and 4 cores(at)2(dot)66Ghz, and it still isn't finished).
To correct myself, I looked at the wrong window earlier, when I typed the email the query had in fact finished already and took about 18 minutes (which is still really long for such a query of course), but more than 30 minutes was wrong.
Express yourself instantly with MSN Messenger! Download today it's FREE!
pgsql-performance by date
|Next:||From: henk de wit||Date: 2007-10-12 21:09:35|
|Subject: Re: Huge amount of memory consumed during transaction|
|Previous:||From: Kevin Grittner||Date: 2007-10-12 20:53:07|
|Subject: Re: How to speed up min/max(id) in 50M rows table?|