Problem with Webrick and Postgres when requesting many records

There seems to be a problem with pag开发者_运维百科es that reques many records (~2,000) from the database. It happens when outputting them to a HTML page or processing them to generate a chart. The page loads, but does not complete loading.

I looked at the config file, but didn't figure out which setting to change. Could it be a data size (memory) or timeout problem? Any suggestions for changing a Webrick or Postgres config setting?

Rails 3.07

Postgres 8.3

Webrick 1.3.1

Ubuntu 11.04

Thanks.

It looks like the weak link is Webrick here. It is very slow by nature. Try using a different server such as passenger.