PostgreSQL configuration

-----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-----