From: | Rod Taylor <rod(dot)taylor(at)gmail(dot)com> |
---|---|
To: | "oliver(at)obeattie(dot)com" <oliver(at)obeattie(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: What you would consider as heavy traffic? |
Date: | 2006-12-29 17:32:39 |
Message-ID: | 89074B26-6DC9-4AA5-9B22-6FFC522EF3D4@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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(at)obeattie(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-12-29 17:44:06 | Re: Backup/Restore too slow |
Previous Message | Rod Taylor | 2006-12-29 17:28:49 | Re: Backup/Restore too slow |