In-Reply-To: <1166861522.996580.25870@42g2000cwt.googlegroups.com>
References: <1166861522.996580.25870@42g2000cwt.googlegroups.com>
Mime-Version: 1.0 (Apple Message framework v752.3)
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
Message-Id: <89074B26-6DC9-4AA5-9B22-6FFC522EF3D4@gmail.com>
Cc: pgsql-performance@postgresql.org
Content-Transfer-Encoding: 7bit
From: Rod Taylor <rod.taylor@gmail.com>
Subject: Re: What you would consider as heavy traffic?
Date: Fri, 29 Dec 2006 12:32:39 -0500
To: "oliver@obeattie.com" <oliver@obeattie.com>

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