Postgres Pro
Downloads
Home   >   mailing lists

Re: count is ten times faster - Mailing list pgsql-performance

From Pierre C
Subject Re: count is ten times faster
Date
Msg-id op.va34p1kxeorkce@immo.peufeu.com
Whole thread Raw
In response to count is ten times faster  ("Sabin Coanda" <coanda@hotpop.com>)
List pgsql-performance
Tree view 
> 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 ?

pgsql-performance by date:

Previous
From: Chris Bowlby
Date:
Subject: Re: significant slow down with various LIMIT
Next
From: Cédric Villemain
Date:
Subject: Re: stats collector suddenly causing lots of IO