Postgres Pro
Downloads
Home   >   mailing lists

Re: How to speed up min/max(id) in 50M rows table? - Mailing list pgsql-performance

From henk de wit
Subject Re: How to speed up min/max(id) in 50M rows table?
Date
Msg-id BAY124-W88F2EFD03BE4A24E21F0EF5A00@phx.gbl
Whole thread Raw
In response to How to speed up min/max(id) in 50M rows table?  (henk de wit <henk53602@hotmail.com>)
List pgsql-performance
Tree view
> 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! MSN Messenger

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: How to speed up min/max(id) in 50M rows table?
Next
From: henk de wit
Date:
Subject: Re: Huge amount of memory consumed during transaction