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.