Re: - Server gives error when I run the sql query

The error message gave you most of the answer. Either increase the available
memory from the OS or decrease the two parameters mentioned. You can set
these in postgresql.conf Look here for details:

http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=runtime-conf
ig.html

(BTW, the cheapest way to increase the RAM available is to use Linux instead
of Win2000 <grin>.)


> > This error usually means that PostgreSQL's request for
> > a shared memory segment exceeded available memory or
> > swap space.  To reduce the request size (currently
> > 1441792 bytes), reduce
> > PostgreSQL's shared_buffers parameter (currently 64)
> > and/or its max_connections parameter (currently 32).