Re: Problem with collector statistic - Mailing list pgsql-general

From Gregory Stark
Subject Re: Problem with collector statistic
Date
Msg-id 87odcmlhu7.fsf@oxford.xeocode.com
Whole thread Raw
In response to Problem with collector statistic  (Marco Aurélio V. da Silva <marcoprodata@gmail.com>)
List pgsql-general
Marco Aurélio V. da Silva <marcoprodata@gmail.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!

pgsql-general by date:

Previous
From: "Sean Z."
Date:
Subject: Deploy postgres - upgrade strategy
Next
From: Magnus Hagander
Date:
Subject: Re: Deploy postgres - upgrade strategy