Connections per second?

From: Alejandro Fernandez <ale(at)electronic-group(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Connections per second?
Date: 2002-04-23 14:51:40
Message-ID: 20020423165140.3d5150bd.ale@electronic-group.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm writing a small but must-be-fast cgi program that for each hit it gets, it reads an indexed table in a postgres database and writes a log to a file based on the result. Any idea how many hits a second I can get to before things start crashing, or queuing up too much, etc? And will postgres be one of the first to fall? Do any of you think it can handle 2000 hits a second (what I think I could get at peak times) - and what would it need to do so? Persistent connections? Are there any examples or old threads on writing a similar program in C with libpq?

Thanks,

Ale

--
Alejandro Fernandez
Electronic Group Interactive
--+34-65-232-8086--

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2002-04-23 14:54:44 Re: Convert "epoch" to timestamp
Previous Message Jeff Eckermann 2002-04-23 14:33:23 Convert "epoch" to timestamp