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

Re: query problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robin Ericsson <robin(dot)ericsson(at)profecta(dot)se>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: query problem
Date: 2004-10-13 15:03:13
Message-ID: 14684.1097679793@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performance
Robin Ericsson <robin(dot)ericsson(at)profecta(dot)se> writes:
> I sent this to general earlier but I was redirected to performance.

Actually, I think I suggested that you consult the pgsql-performance
archives, where this type of problem has been hashed out before.
See for instance this thread:
http://archives.postgresql.org/pgsql-performance/2004-07/msg00169.php
particularly
http://archives.postgresql.org/pgsql-performance/2004-07/msg00175.php
http://archives.postgresql.org/pgsql-performance/2004-07/msg00184.php
http://archives.postgresql.org/pgsql-performance/2004-07/msg00185.php
which show three different ways of getting the planner to do something
sane with an index range bound like "now() - interval".

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Chris BrowneDate: 2004-10-13 15:52:28
Subject: Opteron vs RHAT
Previous:From: kenDate: 2004-10-13 14:37:43
Subject: Re: query problem

pgsql-general by date

Next:From: Robert TreatDate: 2004-10-13 15:11:29
Subject: Re: [GENERAL] Reusable pl/pgsql samples ?
Previous:From: Jason TesserDate: 2004-10-13 15:00:04
Subject: converting database to unicode

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