Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem creating index - Mailing list pgsql-general

From Torello Querci
Subject Re: Problem creating index
Date
Msg-id CA+igE6RQ1Lx31oqAtS7qO6tb3Vf50YAqEzDjgVFYNf2OHf9wtg@mail.gmail.com
Whole thread Raw
In response to Re: Problem creating index  (Florian Weimer <fweimer@redhat.com>)
List pgsql-general
Tree view



2013/8/26 Florian Weimer <fweimer@redhat.com>
On 08/26/2013 04:27 PM, Torello Querci wrote:
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);

What are the data types of these columns?


impianto_id -> integer
tipo_dato_id -> integer
data_misurazione -> date

The index was present in the database before I drop it since one about year and half.


pgsql-general by date:

Previous
From: Florian Weimer
Date:
Subject: Re: Problem creating index
Next
From: Luca Ferrari
Date:
Subject: Re: Problem creating index