Torello Querci escribió: > 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. Note that index creation uses maintenance_work_mem to limit memory used, not work_mem. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
