Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Craig James <craig_james@xxxxxxxxxxxxxx>
Subject: Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception
From: Florian Weimer <fweimer@xxxxxx>
Date: Mon, 15 Sep 2008 10:36:40 +0200
Cc: PostgreSQL Performance <pgsql-performance@xxxxxxxxxxxxxx>, Matthew Wakeling <matthew@xxxxxxxxxxx>
In-reply-to: <48B6EA7E.2090707@xxxxxxxxxxxxxx> (Craig James's message of "Thu, 28 Aug 2008 11:12:14 -0700")
References: <BAY124-W57D3654AF1159CAF8EAC19F5660@xxxxxxx> <82bpze3ou8.fsf@xxxxxxxxxx> <alpine.DEB.1.10.0808271436210.907@xxxxxxxxxxxxxx> <alpine.DEB.1.10.0808281411220.4454@xxxxxxxxxxxxxxxxxxx> <EADBB336-A14E-492C-A8CA-105C8F77A43A@xxxxxxxxxxx> <alpine.DEB.1.10.0808281702450.4454@xxxxxxxxxxxxxxxxxxx> <48B6EA7E.2090707@xxxxxxxxxxxxxx>

* Craig James:

> So it never makes sense to enable overcommitted memory when
> Postgres, or any server, is running.

There are some run-time environments which allocate huge chunks of
memory on startup, without marking them as not yet in use.  SBCL is in
this category, and also the Hotspot VM (at least some extent).

-- 
Florian Weimer                <fweimer@xxxxxx>
BFK edv-consulting GmbH       http://www.bfk.de/
Kriegsstraße 100              tel: +49-721-96201-1
D-76133 Karlsruhe             fax: +49-721-96201-99

Follow-Ups:
- Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception
  - From: Craig James

References:
- select on 22 GB table causes "An I/O error occured while sending to the backend." exception
  - From: henk de wit
- Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception
  - From: Florian Weimer
- Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception
  - From: david
- Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception
  - From: Matthew Wakeling
- Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception
  - From: Steve Atkins
- Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception
  - From: Matthew Wakeling
- Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception
  - From: Craig James

Prev by Date: Re: Choosing a filesystem
Next by Date: Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception
Previous by thread: Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception
Next by thread: Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]