[GENERAL] Problem creating index

[Torello Querci]

Hi to all ....

On my Postgresql 9.1 instance I had a problem with an index.
Using index I get less tuples than expected.
I try to remove index and the query works fine but obviosly the query is
slow so I try to recreate the index.

I run the create index statement but after a lot of time I get this error
message:

ERROR:  unexpected end of tape

I try to look in postgresql and syslog log files but I find nothing.


Any suggestion?


Create index statement that I use is:

CREATE INDEX dati_impianto_id_tipo_dato_id_data_misurazione_idx
  ON dati
  USING btree
  (impianto_id , tipo_dato_id , data_misurazione  DESC);