Re: How to speed up min/max(id) in 50M rows table?
This is a discussion on Re: How to speed up min/max(id) in 50M rows table? within the Pgsql Performance forums, part of the PostgreSQL category; --> > This query takes a totally unrealistic amount of time for execution (I have it running for >30 minutes ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-19-2008, 11:40 AM
| ||||
| ||||
 Re: How to speed up min/max(id) in 50M rows table? > 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@2.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! http://messenger.msn.click-url.com/g...ave/direct/01/      |
Linear Mode
