Postgres Pro
Downloads
Home   >   mailing lists

Re: Planner constants for RAM resident databases - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Planner constants for RAM resident databases
Date
Msg-id 200507051433.28971.josh@agliodbs.com
Whole thread Raw
In response to Re: Planner constants for RAM resident databases  (Emil Briggs <emil@baymountain.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: David Gagnon
Date:
Subject: Re: Why the planner is not using the INDEX .
Next
From: Alexander Stanier
Date:
Subject: Re: Heavy virtual memory usage on production system