Re: slow query performance

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Anj Adu <fotographs(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andy Colson <andy(at)squeakycode(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: slow query performance
Date: 2010-06-11 00:49:48
Message-ID: AANLkTikcvnIgmW_YDg4VSCNCItUvUNbFp_JAUU37pXrj@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Jun 10, 2010 at 12:58 PM, Anj Adu <fotographs(at)gmail(dot)com> wrote:
> you are right..the word "zone" was replaced by "area" (my bad )
>
> everything else is as is.
>
> Apologies for the confusion.

Well, two different people have asked you for the table and index
definitions now, and you haven't provided them... I think it's going
to be hard to troubleshoot this without seeing those definitions (and
also the sizes, which I asked for in my previous email).

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Andy Colson 2010-06-11 02:11:10 Re: Analysis Function
Previous Message David Jarvis 2010-06-11 00:41:51 Re: Analysis Function