is basically a web application and the db size is 37 GB.
How would you classify the load ? small/medium/high ?
Cheers,
ste
Scott Marlowe wrote:
On Fri, Dec 12, 2008 at 3:07 AM, Stefano Nichele
stefano.nich...@gmail.com wrote:
Hi All,
I would like to ask to you, how many connections a db server
.
ste
On Wed, Jan 7, 2009 at 8:05 PM, Stefano Nichele
stefano.nich...@gmail.comwrote:
Ok, here some information:
OS: Centos 5.x (Linux 2.6.18-53.1.21.el5 #1 SMP Tue May 20 09:34:18 EDT
2008 i686 i686 i386 GNU/Linux)
RAID: it's a hardware RAID controller
The disks are 9600rpm SATA drives
(6
Here some number from a mine old pgfouine report:
- query peak: 378 queries/s
- select: 53,1%, insert 3,8%, update 2,2 %, delete 2,8 %
Actually the percentages are wrong (I think pgfouine counts also other types
of query like ET SESSION CHARACTERISTICS AS TRANSACTION READ WRITE;):
These are
, 2009 at 2:02 PM, Stefano Nichele
stefano.nich...@gmail.com wrote:
On Tue, Jan 6, 2009 at 7:45 PM, Scott Marlowe scott.marl...@gmail.com
wrote:
I concur with Merlin you're I/O bound.
Adding to his post, what RAID controller are you running, does it have
cache, does the cache have
Glyn Astill wrote:
--- On Thu, 8/1/09, Stefano Nichele stefano.nich...@gmail.com wrote:
From: Stefano Nichele stefano.nich...@gmail.com
Subject: Re: [PERFORM] understanding postgres issues/bottlenecks
To: Scott Marlowe scott.marl...@gmail.com
Cc: pgsql-performance@postgresql.org
Date
Merlin Moncure wrote:
On Thu, Jan 8, 2009 at 3:36 AM, Stefano Nichele
stefano.nich...@gmail.com wrote:
Find !
Dell CERC SATA RAID 2 PCI SATA 6ch
Running lspci -v:
03:09.0 RAID bus controller: Adaptec AAC-RAID (rev 01)
Subsystem: Dell CERC SATA RAID 2 PCI SATA 6ch (DellCorsair
Ok, here some information:
OS: Centos 5.x (Linux 2.6.18-53.1.21.el5 #1 SMP Tue May 20 09:34:18 EDT
2008 i686 i686 i386 GNU/Linux)
RAID: it's a hardware RAID controller
The disks are 9600rpm SATA drives
(6 disk 1+0 RAID array and 2 separate disks for the OS).
About iostat (on sdb I have
On Tue, Jan 6, 2009 at 7:45 PM, Scott Marlowe scott.marl...@gmail.comwrote:
I concur with Merlin you're I/O bound.
Adding to his post, what RAID controller are you running, does it have
cache, does the cache have battery backup, is the cache set to write
back or write through?
At the
.
Let me know if other info is useful.
Ste
--
Stefano Nichele
Funambol Chief Architect
Funambol :: Open Source Mobile'We' for the Mass Market ::
http://www.funambol.com
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http
:
On Tue, Jan 6, 2009 at 11:50 AM, Stefano Nichele
stefano.nich...@gmail.com wrote:
Hi list,
I would like to ask your help in order to understand if my postgresql server
(ver. 8.2.9) is well configured.
It's a quad-proc system (32 bit) with a 6 disk 1+0 RAID array and 2 separate
disks for the OS
Hi All,
I would like to ask to you, how many connections a db server can handle.
I know the question is not so easy, and actually I don't want to known a
number but something like:
- up to 100 connections: small load, low entry server is enough
- up to 200 connections: the db server starts to
11 matches
Mail list logo