Search Postgresql Archives

Re: Problem creating index

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

 




2013/8/26 Luca Ferrari <fluca1978@xxxxxxxxxxx>
On Mon, Aug 26, 2013 at 4:27 PM, Torello Querci <tquerci@xxxxxxxxx> wrote:
> ERROR:  unexpected end of tape

Really strange, if I get it right something went wrong while sorting tuples.
Is it possible to test with an incremented work_mem value?

Actually I use the default work_set value (1MB).
Of course it is possible increase work_set value to any values. 
Now I'll try with 10MB (shared_buffers is set to 412MB).
If you think that 10MB is a very low value for a table with million of records I can try to increase work_set value to higher value.

Best Regards, Torello



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux