Skip site navigation (1) Skip section navigation (2)

SQL With Dates

From: Rafael Domiciano <rafael(dot)domiciano(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: SQL With Dates
Date: 2009-04-20 13:55:36
Message-ID: 3a0028490904200655n53209fbbxf6010c60b024e029@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
Hello People,

I have initiated a work to review the sqls of our internal software.
Lot of them he problem are about sql logic, or join with table unecessary,
and so on.
But software has lot of sql with date, doing thinks like:
[..]
  date >= '2009-04-01' AND
  date <= '2009-04-15'
[..]

Redoing the SQL with fix date (date = '2009-04-01') o cost in explain always
still about 200 or less. But with a period the cost is high, about 6000 or
more.

Select is using Index and the date is using index too.

There is some way to use date period with less cost?

Rafael Domiciano

Responses

pgsql-performance by date

Next:From: Matthew WakelingDate: 2009-04-20 14:11:08
Subject: Re: GiST index performance
Previous:From: Tom LaneDate: 2009-04-19 23:31:51
Subject: Re: No hash join across partitioned tables?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group