Search Postgresql Archives

Re: PostgreSQL configuration

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux