PostgreSQL configuration

From: "Leticia" <lgomez(at)itba(dot)edu(dot)ar>
To: <pgsql-novice(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: PostgreSQL configuration
Date: 2007-04-21 20:06:35
Message-ID: !&!AAAAAAAAAAAYAAAAAAAAAIp4oCwdczpFp3BQ+cTGVObCgAAAEAAAADZ8+9gCVWJPnUEcoWcTWy8BAAAAAA==@itba.edu.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

Hi Community,

I have a server with Linux Fedora Core 6 and PostgreSQL 8.2.3.
The server has 4 G of RAM

I want to configure 1.2 G de RAM only for PostgreSQL. Which
could be a good setting?

When I try to run a join of three tables, PostgreSQL seems to be
hanged, although the join must return cero tuples.

Thanks in advance,

Leticia

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Allison 2007-04-21 20:53:55 permissions
Previous Message Tom Lane 2007-04-21 16:29:57 Re: Regular Expression Data Type

Browse pgsql-novice by date

  From Date Subject
Next Message Andrew Jarcho 2007-04-21 21:40:31 call pl/pgsql stored functions from ecpg?
Previous Message Stephen Cook 2007-04-21 09:54:23 Re: Clustered index?