pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Gregory Stark <stark@enterprisedb.com>
To: Carlos Moreno <moreno_pg@mochima.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Possible explanations for catastrophic performance deterioration?
Date: Mon, 24 Sep 2007 00:05:31 +0100
Message-ID: <874phlugn8.fsf@oxford.xeocode.com> (raw)
In-Reply-To: <46F6E0E5.3080208@mochima.com>
References: <46F6981B.1010600@mochima.com>
	<36e682920709230956p1312745eif1c6ba7a342dae3d@mail.gmail.com>
	<46F6AD2D.4090300@mochima.com>
	<20070923182349.GC5679@alvh.no-ip.org>
	<46F6BA82.3080101@mochima.com>
	<36e682920709231224y3fb13ce3t9dd4217215c62bf7@mail.gmail.com>
	<46F6CD9A.2090600@mochima.com>
	<20070923205759.GD5679@alvh.no-ip.org>
	<46F6E0E5.3080208@mochima.com>

"Carlos Moreno" <moreno_pg@mochima.com> writes:

> I'm now thinking that the problem with my logic is that the system does
> not keep anything in memory (or not all tuples, in any case), since it
> is only counting, so it does not *have to* keep them

That's really not how it works. When Postgres talks to the OS they're just
bits. There's no cache of rows or values or anything higher level than bits.
Neither the OS's filesystem cache nor the Postgres shared memory knows the
difference between live or dead rows or even pages that don't contain any
rows.

>  and since the total amount of reading from the disk exceeds the amount of
> physical memory, then the valid tuples are "pushed out" of memory.

That's right.

-- 
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com



view thread (12+ messages)

Message-ID: <874phlugn8.fsf@oxford.xeocode.com>
Permalink:  ../874phlugn8.fsf@oxford.xeocode.com/
Also on:    postgresql.org/message-id/874phlugn8.fsf@oxford.xeocode.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: stark@enterprisedb.com, moreno_pg@mochima.com
  Subject: Re: Possible explanations for catastrophic performance deterioration?
  In-Reply-To: <874phlugn8.fsf@oxford.xeocode.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox