Re: PostgreSQL configuration

[Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>]

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