Re: query performance, though it was timestamps, maybe just table size?

From: Henry Drexler <alonup8tb(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: query performance, though it was timestamps, maybe just table size?
Date: 2012-11-30 13:32:22
Message-ID: CAAtgU9TNigm2cF-b2EGkM40g2MiZak1viMTFKaxqX+mRra5DhQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Nov 30, 2012 at 8:22 AM, Henry Drexler <alonup8tb(at)gmail(dot)com> wrote:

> Hello, and thank you in advance.
>
>
> Beyond the date vs timestamp troubleshooting I did,
>

I realize this could be confusing - since I ruled out that difference, the
real question is - given this setup, why would the query time go from 4
minutes to over 50, for an increase in table rows from 30 million to 65
million?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Greco 2012-11-30 13:38:42 Re: UPDATE syntax
Previous Message ivan marchesini 2012-11-30 13:25:24 Re: difference in query performance due to the inclusion of a polygon geometry field