Postgres Pro
Downloads
Home   >   mailing lists

Re: Trying to figure out why these queries are so slow - Mailing list pgsql-general

From Tim Uckun
Subject Re: Trying to figure out why these queries are so slow
Date
Msg-id AANLkTinxM6N3P2-oK+wPxX_g=1-jM8A94rBP8UhTh+TQ@mail.gmail.com
Whole thread Raw
In response to Trying to figure out why these queries are so slow  (Tim Uckun <timuckun@gmail.com>)
List pgsql-general
Tree view 
On Tue, Oct 5, 2010 at 10:33 PM, Thomas Guettler <hv@tbz-pariv.de> wrote:
> Hi,
>
> just a guess: Counting is slow, since it needs to check all rows. Explained here:
>

Actually counting was pretty fast. As I said when I created a table
using the subquery that went pretty fast. The update was the slow
part.

pgsql-general by date:

Previous
From: Tim Uckun
Date:
Subject: Trying to figure out why these queries are so slow
Next
From: "Vishnu S."
Date:
Subject: Re: Data Not replicating