Problems creating index
От | Denis Perchine |
---|---|
Тема | Problems creating index |
Дата | |
Msg-id | 0010181938030W.17427@dyp.perchine.com обсуждение исходный текст |
Список | pgsql-general |
Hello, I try to create index for a table. It is serial field. Table have > 10^6 records. Table itself occupies approx. 220Mb. There's 1.1Gb on the disk available. I get this error third time... What might be wrong? psql:/home/www/www.webmailstation.com/sql/reindex.sql:58: NOTICE: !!! write error seems permanent !!! psql:/home/www/www.webmailstation.com/sql/reindex.sql:58: NOTICE: !!! now kill all backends and reset postmaster !!! psql:/home/www/www.webmailstation.com/sql/reindex.sql:58: ERROR: cannot write block 2220 of stats_id_key_1 [webmailstation] blind pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally before or while processing the request. psql:/home/www/www.webmailstation.com/sql/reindex.sql:58: connection to server was lost -- Sincerely Yours, Denis Perchine ---------------------------------- E-Mail: dyp@perchine.com HomePage: http://www.perchine.com/dyp/ FidoNet: 2:5000/120.5 ----------------------------------
В списке pgsql-general по дате отправления: