Re: Planner constants for RAM resident databases

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: emil(at)baymountain(dot)com
Cc: John A Meinel <john(at)arbash-meinel(dot)com>, Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Planner constants for RAM resident databases
Date: 2005-07-05 21:33:28
Message-ID: 200507051433.28971.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Emil,

> -> Merge Left Join (cost=9707.71..13993.52 rows=1276 width=161)
> (actual time=164.423..361.477 rows=49 loops=1)

That would indicate that you need to either increase your statistical
sampling (SET STATISTICS) or your frequency of running ANALYZE, or both.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Alexander Stanier 2005-07-06 12:03:44 Re: Heavy virtual memory usage on production system
Previous Message David Gagnon 2005-07-05 17:53:59 Re: Why the planner is not using the INDEX .