2013/8/26 Tom Lane <tgl@xxxxxxxxxxxxx>
Torello Querci <tquerci@xxxxxxxxx> writes:
> 2013/8/26 Luca Ferrari <fluca1978@xxxxxxxxxxx>maintenance_work_mem is what would be used for CREATE INDEX.
>> Is it possible to test with an incremented work_mem value?
> Actually I use the default work_set value (1MB).
Ok .... thanks
FWIW, though, the combination of this weird error and the fact that you
had a corrupt index to begin with makes me suspicious that there's some
low-level problem. You might be well advised to do some memory testing
on that machine, for example.
I check for ecc memory but unfortunally the machine use non ecc memory.
This machine is installed on a remote site so I should to try to use e memory tester in normal linux shell, so I can't use memtest at boot level.
In this moment I get this error while executing the restore of the big table in a different database on the same machine:
psql:dump_ess_2013_08_26.sql:271177424: SSL error: sslv3 alert unexpected message
psql:dump_ess_2013_08_26.sql:271177424: connection to server was lost
I was connected with psql -h localhost.
Any other suggestion?
Best Regards