Postgres Pro
Downloads
Home   >   mailing lists

Thread: PostgreSQL configuration

PostgreSQL configuration

From
"Leticia"
Date:

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

 

 

 

Re: PostgreSQL configuration

From
Ron Johnson
Date:
-----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-----