Re: What limits Postgres performance when the whole database lives in cache? - Mailing list pgsql-general

From 'Bruce Momjian'
Subject Re: What limits Postgres performance when the whole database lives in cache?
Date
Msg-id 20160903020128.GB3838@momjian.us
Whole thread Raw
In response to Re: What limits Postgres performance when the whole database lives in cache?  ("dandl" <david@andl.org>)
List pgsql-general
On Sat, Sep  3, 2016 at 10:45:47AM +1000, dandl wrote:
> > Agreed. Stonebraker measured Shore DBMS, which is an academic
> > database:
> >
> >     http://research.cs.wisc.edu/shore/
> >
> > If he had measured a production-quality database that had been
> > optimized like Postgres, I would take more stock of his "overhead"
> > numbers.
>
> Exactly! And that's what I'm asking: has anyone done or know of any figures for Postgres, to set against these?

Uh, well, there are Postgres tools that measure the overhead of locking
on queries and stuff.  I don't know any numbers myself.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+                     Ancient Roman grave inscription +


pgsql-general by date:

Previous
From: "dandl"
Date:
Subject: Re: What limits Postgres performance when the whole database lives in cache?
Next
From: "dandl"
Date:
Subject: Re: What limits Postgres performance when the whole database lives in cache?