Dear,
Thanks, this solved my problem. I was using very low values for
effective_cache_size.
Thanks for your attention,
Marco Aurélio V. da Silva
Prodata Inf. e Cad. Ltda.
MSN: marco@xxxxxxxxxxxxxxxxx
Fone: (33) 3322-3082
----- Original Message -----
From: "Scott Marlowe" <scott.marlowe@xxxxxxxxx>
To: "Marco Aurélio V. da Silva" <marcoprodata@xxxxxxxxx>
Cc: "Tom Lane" <tgl@xxxxxxxxxxxxx>; <pgsql-general@xxxxxxxxxxxxxx>
Sent: Wednesday, December 19, 2007 4:16 PM
Subject: Re: Problem with collector statistic
On Dec 19, 2007 2:06 PM, Marco Aurélio V. da Silva
<marcoprodata@xxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
