"Craig A. James" <[EMAIL PROTECTED]> writes:
> Here's something I found googling for "memory overcommitment"+linux
> http://archives.neohapsis.com/archives/postfix/2000-04/0512.html
That might have been right when it was written (note the reference to a
2.2 Linux kernel), but it's 100% wrong now
Richard Troy wrote:
I did that - spent about two f-ing hours looking for what I wanted. (Guess
I entered poor choices for my searches. -frown- ) There are a LOT of
articles that TALK ABOUT OOM, but prescious few actually tell you what you
can do about it.
Trying to save you some time:
On linux
-- Forwarded message --
From: rakesh kumar <[EMAIL PROTECTED]>
Date: Nov 19, 2006 9:31 AM
Subject: Re: [PERFORM] start up cost estimate
To: Joshua Marsh <[EMAIL PROTECTED]>
Hi
for suppose if I had a
query , something like :
On 18-Nov-06, at 11:30 AM, Tom Lane wrote:
Dave Cramer <[EMAIL PROTECTED]> writes:
On 16-Nov-06, at 7:03 PM, Brian Wipf wrote:
Has anyone else noticed this limitation on OS X? Any ideas on how I
might get shared_buffers higher than 284263?
My guess is something else has taken shared memory a
On Thu, 16 Nov 2006, Tom Lane wrote:
>
> "Craig A. James" <[EMAIL PROTECTED]> writes:
> > OOM? Can you give me a quick pointer to what this acronym stands for
> > and how I can reconfigure it?
>
> See "Linux Memory Overcommit" at
> http://www.postgresql.org/docs/8.1/static/kernel-resources.html#
Hi.
I've sent this out once, but I think it didn't make it through the
mail server ... don't know why. If it is a double post - sorry for it.
Brian Wipf <[EMAIL PROTECTED]> wrote:
> I'm trying to optimize a PostgreSQL 8.1.5 database running on an
> Apple G5 Xserve (dual G5 2.3 GHz w/ 8GB of
Brian Wipf <[EMAIL PROTECTED]> wrote:
> I'm trying to optimize a PostgreSQL 8.1.5 database running on an
> Apple G5 Xserve (dual G5 2.3 GHz w/ 8GB of RAM), running Mac OS X
> 10.4.8 Server.
>
> The queries on the database are mostly reads, and I know a larger
> shared memory allocation will
Dave Cramer <[EMAIL PROTECTED]> writes:
> On 16-Nov-06, at 7:03 PM, Brian Wipf wrote:
>> Has anyone else noticed this limitation on OS X? Any ideas on how I
>> might get shared_buffers higher than 284263?
> My guess is something else has taken shared memory ahead of you. OS X
> seems to be som
"rakesh kumar" <[EMAIL PROTECTED]> writes:
> I wanted to know , how the start up cost is computed in postgresql
Look into
http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/costsize.c
regards, tom lane
---(end of b
Brian,
On 16-Nov-06, at 7:03 PM, Brian Wipf wrote:
I'm trying to optimize a PostgreSQL 8.1.5 database running on an
Apple G5 Xserve (dual G5 2.3 GHz w/ 8GB of RAM), running Mac OS X
10.4.8 Server.
The queries on the database are mostly reads, and I know a larger
shared memory allocation w
On 11/18/06, rakesh kumar <[EMAIL PROTECTED]> wrote:
Hi ,
I wanted to know , how the start up cost is computed in
postgresql . can u give me an example to illustrate the estimation of start
up cost .
thanku raa .
It would
Hi...
Bacula does no transaction right now, so every insert is done separately with
autocommit.
Moreover, the insert loop for the main table is done by several individual
queries to insert data in several tables (filename, dir, then file), so this
is slow.
There's work underway to speed that up,
Hi ,
I wanted to know , how the start up cost is computed in postgresql
. can u give me an example to illustrate the estimation of start up cost .
thanku raa .
13 matches
Mail list logo
