| From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL configuration |
| Date: | 2007-04-21 23:13:11 |
| Message-ID: | 462A9A87.7020606@cox.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice |
-----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-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Arthaey Angosii | 2007-04-22 01:31:57 | Indirect access to data, given table name as a string |
| Previous Message | Kris Jurka | 2007-04-21 22:42:14 | Re: large table problem |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jasbinder Singh Bali | 2007-04-21 23:53:15 | Re: call pl/pgsql stored functions from ecpg? |
| Previous Message | Andrew Jarcho | 2007-04-21 21:40:31 | call pl/pgsql stored functions from ecpg? |