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

From Tom Lane
Subject Re: Problem with collector statistic
Date
Msg-id 24358.1198084167@sss.pgh.pa.us
Whole thread Raw
In response to Problem with collector statistic  (Marco Aurélio V. da Silva <marcoprodata@gmail.com>)
List pgsql-general
"=?iso-8859-1?Q?Marco_Aur=E9lio_V._da_Silva?=" <marcoprodata@gmail.com> writes:
> Running a query on 2 database-equal, with the same indices, but with
> slightly different data, I have a very different result of performance. In
> one the index is used to make the join, in another it is seqscan.

The fact that one explain includes a Limit step, and the other does not,
says that you are not really issuing the same query in both cases.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Getting char * from timestamp in a composite type
Next
From: "Sean Z."
Date:
Subject: Deploy postgres - upgrade strategy