Connections per second? - Mailing list pgsql-general

From Alejandro Fernandez
Subject Connections per second?
Date
Msg-id 20020423171230.70031774.ale@e-group.org
Whole thread Raw
Responses Re: Connections per second?
List 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
databaseand writes a log to a file based on the result. Any idea how many hits a second I can get to before things
startcrashing, or queuing up too much, etc? And will postgres be one of the first to fall? Do any of you think it can
handle2000 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--

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Convert "epoch" to timestamp
Next
From: Sheer El-Showk
Date:
Subject: recursive subquery