> > I need to run about 1000 PostgreSQL connections on a server that I can > > use about 4 GB of the total 16 GB of total RAM. It seems that each > > session creates a process that uses about 15 MB of RAM just for > > connecting so I'm running out of RAM rather quickly. > > I think you're being bitten by a different problem than it appears. > Windows > has a fixed size per-session shared memory pool which runs out rather > quickly. > You can raise that parameter though. (The 125 mentioned there is raised to > about 300 with Pg 8.3.) > > See: > > http://www.postgresql.org/docs/faqs.FAQ_windows.html#4.4 > >
Thanks for the tip and I'll be moving this to the performance forum. Although, with 8.3, it seems that the FAQ is out of date? Jon ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
