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
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