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);
