From: | Torello Querci <tquerci(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Problem creating index |
Date: | 2013-08-26 14:27:45 |
Message-ID: | CA+igE6TmuEkV0swtWNfZhvYODAh_o4vorsXWwJG8LBeNUOsTbw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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);
From | Date | Subject | |
---|---|---|---|
Next Message | Fujii Masao | 2013-08-26 14:29:15 | Re: Re: postmaster.pid still exists after pacemaker stopped postgresql - how to remove |
Previous Message | Mistina Michal | 2013-08-26 14:02:30 | Re: Re: postmaster.pid still exists after pacemaker stopped postgresql - how to remove |