What you would consider as heavy traffic?
This is a discussion on What you would consider as heavy traffic? within the Pgsql Performance forums, part of the PostgreSQL category; --> Hey Everyone, I am having a bit of trouble with a web host, and was wondering as what you ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-19-2008, 09:59 AM
| ||||
| ||||
 What you would consider as heavy traffic? Hey Everyone, I am having a bit of trouble with a web host, and was wondering as what you would class as a high level of traffic to a database (queries per second) to an average server running postgres in a shared hosting environment (very modern servers). Many Thanks in Advance, Oliver      |
|
04-19-2008, 10:00 AM
| ||||
| ||||
| Re: What you would consider as heavy traffic? Depends on what the query is. If the queries take 3 to 5 days to execute, then 1 query per day on a 4 CPU machine would be at capacity. On 23-Dec-06, at 3:12 AM, oliver@obeattie.com wrote: > Hey Everyone, > > I am having a bit of trouble with a web host, and was wondering as > what > you would class as a high level of traffic to a database (queries per > second) to an average server running postgres in a shared hosting > environment (very modern servers). > > Many Thanks in Advance, > Oliver > > > ---------------------------(end of > broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq |
Linear Mode
