Re: Troubles with performances - Mailing list pgsql-general

From Oliver Elphick
Subject Re: Troubles with performances
Date
Msg-id 200101182118.f0ILI5q31876@linda.lfix.co.uk
Whole thread Raw
In response to RE: Troubles with performances  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
List pgsql-general
"Mikheev, Vadim" wrote:
  >FAQ is wrong - you don't have *enough* of shared memory -:)
  >I don't know how to increase shmem segment size in Linux.

If you have  /proc/sys/kernel/shmmax, try (as root):

   cat new_bigger_value >  /proc/sys/kernel/shmmax

If it won't allow you to do that, you may have to recompile the kernel
instead.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47  6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "For the eyes of the LORD run to and fro throughout the
      whole earth, to show himself strong in the behalf of
      them whose heart is perfect toward him..."
                                   II Chronicles 16:9



pgsql-general by date:

Previous
From: Lamar Owen
Date:
Subject: Re: Troubles with performances
Next
From: Tom Lane
Date:
Subject: Re: Another optimizer question