You could lower your sort_mem value.
32168 means 32 meg per backend.
douglas
Kurt Overberg wrote:
> Gang,
>
> Got a question about run-time postgresql memory usage. I'm moving
> over to this RedHat box from a shared sun server, so I'm doing some
> tweaking out of the system. I'm running pgsql 7.3 on a RedHat system
> (fairly recent- not sure of the version) that has 1Gb of memory.
> Using apache with tomcat 4.1.2/Struts/JDBC2 drivers. I have shared
> memory on the system set to 268435456 (roughly 256Mb). Tomcat/Struts
> (jdbc2) is configured to have 100 max connections (maxCount), minimum
> of 10 (minCount).
>
>
> The relevant parts of my postgresql config are:
>
> tcpip_socket = true
> max_connections = 128
> shared_buffers = 30400
> sort_mem = 32168
> vacuum_mem = 32168
>
> [...]