Re: [PERFORMANCE] work_mem vs temp files issue

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Jaime Casanova <jcasanov@xxxxxxxxxxxxxxxxxxx> writes:
> why we don't show some of that info in explain?

Lack of round tuits; plus concern about breaking programs that read
EXPLAIN output, which I guess will be alleviated in 8.5.

> the reason i say "most of the temp files" is that when i removed
> #ifdef HJDEBUG it says that in total i was using 10 batchs but there
> were 14 temp files created (i guess we use 1 file per batch, no?)

Two files per batch, in general --- I suppose some of the buckets
were empty.

			regards, tom lane

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux