[GENERAL] Doubts on startup costs

Hi, A few academic questions related PostgreSQL query planner and output - In the output of EXPLAIN for SQL statements I have seen so far, the startup cost for the innermost node/leaf has been 0. Are there situations where it may be non-zero? The startup costs for outer nodes will always be

Re: [GENERAL] Postgres as In-Memory Database?

Hi Jeff 2013/11/20 Jeff Janes jeff.ja...@gmail.com On Mon, Nov 18, 2013 at 5:39 PM, Stefan Keller sfkel...@gmail.com wrote: Hi Jeff and Martin On 18. November 2013 17:44 Jeff Janes jeff.ja...@gmail.com wrote: I rather doubt that. All the bottlenecks I know about for well cached

[GENERAL] Why does checkpointer is consumig ~1.2Gb of RAM?

I'm curious about the "checkpointer" process and its configuration. What are the configuration options that affects the checkpointer process? Currently, under load, this process goes up to about 1.2GB of RAM: --

Re: [GENERAL] Why does checkpointer is consumig ~1.2Gb of RAM?

On Sun, Mar 30, 2014 at 8:43 PM, Edson Richter edsonrich...@hotmail.comwrote: I'm curious about the checkpointer process and its configuration. What are the configuration options that affects the checkpointer process? Currently, under load, this process goes up to about 1.2GB of RAM: --