[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

Re: [GENERAL] unexpected external sort Disk

2013-06-20 Thread Jeff Janes
On Thu, Jun 20, 2013 at 6:12 AM, Manuel Kniep rap...@adeven.com 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