Memory usage / concept

Hi, I'm a novice in PostgreSql. I'm used to work with Oracle. I'm testing
PostgreSql (7.2) on linux RedHat 7.1 and Solaris 8. I have some problems
with large queries : for example a "select * from my_table ..." and my_table
with a size of several Gb and several Mrows. If I set the ulimit to
"unlimited", I overflow my memory and my swap; if I limit it, my query
crashes. In fact I don't know how PG works with the memory use :
with Oracle I have to manage its memory space (the SGA); is there anything
like that with PG ?
Thanks, Valerie.



********************************************************************
*    Les points de vue exprimes sont strictement personnels et     *
*      n'engagent pas la responsabilite de METEO-FRANCE.           *
********************************************************************
* Valerie SCHNEIDER             Tel : +33 (0)5 61 07 81 91         *
* METEO-FRANCE / DSI/DEV        Fax : +33 (0)5 61 07 81 09         *
* 42, avenue G. Coriolis        Email : Valerie.Schneider@meteo.fr *
* 31057 TOULOUSE Cedex - FRANCE         http://www.meteo.fr        *
********************************************************************