Re: Problem with collector statistic

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: Marco Aurélio V(dot) da Silva <marcoprodata(at)gmail(dot)com>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: Problem with collector statistic
Date: 2007-12-19 19:16:44
Message-ID: dcc563d10712191116v3e54f72coa626035332a1869e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Dec 19, 2007 2:06 PM, Marco Aurélio V. da Silva
<marcoprodata(at)gmail(dot)com> wrote:
> Sorry,
>
> I discovered that the problem appears to be another, doing tests with the
> same database, this is a consultation limit using the same database and with
> 9364 records of the problem, and with 9363 not of.

Sounds like pgsql is switching to a sequential scan a little too
quickly for your dataset / server / etc...

I'd say look at increasing effective_cache_size and lowering random_page_cost

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matt Magoffin 2007-12-19 19:16:52 Re: Way to avoid expensive Recheck Cond in index lookup?
Previous Message Howard Cole 2007-12-19 18:58:14 Re: Killing a session in windows