Re: strange query filter problems

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Jonas Henriksen <jonas(dot)f(dot)henriksen(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: strange query filter problems
Date: 2006-04-19 11:35:45
Message-ID: 20060419113545.GG15420@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Apr 19, 2006 at 01:27:45PM +0200, Jonas Henriksen wrote:
> Hi,
> I have a problem with a slow query. (I have run vacuum full analyze!)
> It seems that the query below works OK because the query planner
> filters on the date first. It takes about 0.3 sec:

Can we see an EXPLAIN ANALYZE of the two queries, so we can see what's
actually happening? My guess is that in the second case, the index scan
on sskjema matches more rows than it expects...

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jonas Henriksen 2006-04-19 11:53:46 Re: strange query filter problems
Previous Message chris smith 2006-04-19 11:31:12 Re: How to implement a "subordinate database"?