Search Postgresql Archives

R: Special index for "like"-based query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: R: Special index for "like"-based query
From: Job <Job@xxxxxxxxxxxxxxxxxxxx>
Date: Fri, 30 Dec 2016 13:49:58 +0100
Accept-language: it-IT
Acceptlanguage: it-IT
Cc: Francisco Olarte <folarte@xxxxxxxxxxxxxx>, "David G. Johnston" <david.g.johnston@xxxxxxxxx>, "pgsql-general@xxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <0C13A9E5-FA35-4273-A864-7E80440E41B2@gmail.com>
References: <88EF58F000EC4B4684700C2AA3A73D7A08054EAEBAE7@W2008DC01.ColliniConsulting.lan> <CAKFQuwaAPR0_ki2OPGwXtK1MzpLECZHeDnd1Rkvb3zh7_Vdtag@mail.gmail.com> <88EF58F000EC4B4684700C2AA3A73D7A08054EAEBAE8@W2008DC01.ColliniConsulting.lan> <88EF58F000EC4B4684700C2AA3A73D7A08054EAEBAE9@W2008DC01.ColliniConsulting.lan> <CA+bJJbx8iSSp90=qHBr8NiFtGHriSxr39Q7avMDHeyNbNBpG1Q@mail.gmail.com> <88EF58F000EC4B4684700C2AA3A73D7A08054EAEBAEA@W2008DC01.ColliniConsulting.lan> <0C13A9E5-FA35-4273-A864-7E80440E41B2@gmail.com>

Hi Alban,

I was wrong: i have only one column: tsrarnge.

Which index can i create to use this statement fastly:
 ... AND timestamp <@ '[2016-12-27 00:00:00, 2016-12-31 00:00:00)'::tsrange

Thank you again!

/F

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Special index for "like"-based query
  - From: Job
- Re: Special index for "like"-based query
  - From: David G. Johnston
- R: Special index for "like"-based query
  - From: Job
- R: Special index for "like"-based query
  - From: Job
- Re: Special index for "like"-based query
  - From: Francisco Olarte
- R: Special index for "like"-based query
  - From: Job
- Re: Special index for "like"-based query
  - From: Alban Hertroys

Prev by Date: R: Special index for "like"-based query
Next by Date: Re: Special index for "like"-based query
Previous by thread: R: Special index for "like"-based query
Next by thread: Re: Special index for "like"-based query
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]