Re: Problem with collector statistic

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: Marco Aurélio V(dot) da Silva <marcoprodata(at)gmail(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Problem with collector statistic
Date: 2007-12-19 17:22:56
Message-ID: 87odcmlhu7.fsf@oxford.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Marco Aurélio V. da Silva <marcoprodata(at)gmail(dot)com> writes:

> Select a.CodPagador,b.Descricao
> From Frete01 a Left Outer Join Frete02 b On (a.CodPagador = b.CodCliente)
>
> explain in good dabatase:
> "Limit (cost=0.00..46856.62 rows=55204 width=39) (actual
> time=11.205..536.761 rows=55204 loops=1)"

That doesn't match the query you describe. Notably there's no LIMIT in the
query (or the other plan)

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's Slony Replication support!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2007-12-19 17:39:11 Re: Deploy postgres - upgrade strategy
Previous Message Sean Z. 2007-12-19 17:12:34 Deploy postgres - upgrade strategy