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 6: explain analyze is your friend
