Re: PostgreSQL configuration - Mailing list pgsql-general

From Ron Johnson
Subject Re: PostgreSQL configuration
Date
Msg-id 462A9A87.7020606@cox.net
Whole thread Raw
In response to PostgreSQL configuration  ("Leticia" <lgomez@itba.edu.ar>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 04/21/07 15:06, Leticia wrote:
> 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.

*Hangs* like "all activity grinds to a halt", or "seems to hang
because the disks are grinding away"?

Do indexes support the join?

- --
Ron Johnson, Jr.
Jefferson LA  USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGKpqGS9HxQb37XmcRAqwhAJ9KCZ8S7uNn7c9b5DTYXenvhqm3HQCgjjP3
j6sn9ceebUZVu+of2hEX7tc=
=UTVS
-----END PGP SIGNATURE-----

pgsql-general by date:

Previous
From: Kris Jurka
Date:
Subject: Re: large table problem
Next
From: Steve Atkins
Date:
Subject: Re: ERROR: Failed to build any 5-way joins