Re: Postgres not using shared memory

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: "Karl O(dot) Pinc" <kop(at)meme(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres not using shared memory
Date: 2004-12-10 21:30:56
Message-ID: 878y85zvqn.fsf@asmodeus.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Karl O. Pinc" <kop(at)meme(dot)com> writes:

> Hi,
>
> I can't seem to get postgresql to use shared memory and performance is
> terrrible.

1) Linux doesn't track shared pages (which is not the same as shared
memory) anymore--the field the in 'free' output is just there to
avoid breaking software. Use the 'ipcs' command to list shared
memory segments--you'll find Postgres is using what you told it to
(otherwise it woudn't start up at all).
2) The -performance list is a good place to find out why queries are
running slowly.

-Doug

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pablo Santiago Blum de Aguiar 2004-12-10 21:31:15 How to get rid of notices for create table?
Previous Message Marc G. Fournier 2004-12-10 21:07:12 Servers live ... news at 11 ...