Re: count is ten times faster

From: "Pierre C" <lists(at)peufeu(dot)com>
To: "Sabin Coanda" <coanda(at)hotpop(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: count is ten times faster
Date: 2010-04-13 18:09:27
Message-ID: op.va34p1kxeorkce@immo.peufeu.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> How do you explain the cost is about ten times lower in the 2nd query
> than the first ?

Function call cost ?

Can you EXPLAIN ANALYZE ?

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Cédric Villemain 2010-04-13 18:13:50 Re: stats collector suddenly causing lots of IO
Previous Message Chris Bowlby 2010-04-13 17:59:55 Re: significant slow down with various LIMIT