Re: Question slow query

John R Pierce <pierce@xxxxxxxxxxxx> · Fri, 27 Jan 2017 03:01:33 -0800



    On 1/16/2017 11:27 AM, Patrick B wrote:

    
      Sorry about that.. just wanted to understand how to index a
        timestamp column. I was able to do this way:
      

        CREATE
          INDEX CONCURRENTLY ON note (timezone('Etc/UTC'::text,
          d_date));
      

    why did you prefix your index with timezone('etc/UTC'::text ???  
      that doesn't make sense to me at all.   is timezone() some
      function you've defined?  I'm not aware of any built in function
      by that name.

    
    create index concurrently on table(columnname);   should index a
      timestamp column, the same as any other column.
    

    you still haven't told us what query it is thats taking 25
      seconds.

    
    -- 
john r pierce, recycling bits in santa cruz