Re: Optimize date query for large child tables: GiST or GIN?

[David Jarvis <thangalin@xxxxxxxxx>]

What if I were to have the application pass in two sets of date ranges?

For the condition of Dec 22 to Mar 22:

Dec 22 would become:

• Dec 22 - Dec 31
  

Mar 22 would become:

• Jan 1 - Mar 22
  

The first range would always be for the current year; the second range would always be for the year following the current year.

Would that allow PostgreSQL to use the index?

Dave