Re: [GENERAL] unexpected external sort Disk

2013-06-20 Thread Jeff Janes
On Thu, Jun 20, 2013 at 6:12 AM, Manuel Kniep wrote: > Hello, > > I have table with 37 million entries the whole table has a size of 2.3 GB > > Although I have set the work_mem to 10 GB > There is one piece of memory used in in-memory sorting that (currently) has to be a single contiguous allo

[GENERAL] unexpected external sort Disk

2013-06-20 Thread Manuel Kniep
Hello, I have table with 37 million entries the whole table has a size of 2.3 GB Although I have set the work_mem to 10 GB I see the an unexpected external sort Disk in Explain Analyze for around 650MB of data EXPLAIN ANALYZE SELECT application_id, price_tier FROM application_prices orde