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