| From: | Jakub Ouhrabka <jouh8664(at)ss1000(dot)ms(dot)mff(dot)cuni(dot)cz> |
|---|---|
| To: | Valerie Schneider DSI/DEV <Valerie(dot)Schneider(at)meteo(dot)fr> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Memory usage / concept |
| Date: | 2002-08-05 14:07:36 |
| Message-ID: | Pine.LNX.4.44.0208051601230.7152-100000@server |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> >i think it's your client (psql) what's actually crashing. it's attempting
>
> Yes it is. But without using a cursor (and even if this kind of query isn't
> recommended) is there any solution to limit the use of the memory by PG itself
> (as for Oracle) ?
if you want to limit memory usage of psql (the client program), use
standard *nix tools - there isn't anything i know about in config etc...
if you want to limit memory usage of postgresql server itself, use
configuration parametrs shared_buffers and sort_mem. see:
http://www.postgresql.org/idocs/index.php?runtime-config.html
kuba
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-08-05 14:14:36 | Re: Foreign keys: referencing a REFERENCES doesn7t work? |
| Previous Message | Tom Lane | 2002-08-05 13:44:01 | Re: O'Reilly Open Source Convention Report |