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
wrote:
Hi All,
I would like to ask to you, how many connections a db server can handle. I
know the
> 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 a
.
ste
On Wed, Jan 7, 2009 at 8:05 PM, Stefano Nichele
wrote:
> 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 driv
Merlin Moncure wrote:
On Thu, Jan 8, 2009 at 3:36 AM, Stefano Nichele
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)
IIRC that's the
Glyn Astill wrote:
--- On Thu, 8/1/09, Stefano Nichele wrote:
From: Stefano Nichele
Subject: Re: [PERFORM] understanding postgres issues/bottlenecks
To: "Scott Marlowe"
Cc: pgsql-performance@postgresql.org
Date: Thursday, 8 January, 2009, 8:36 AM
Find !
Dell CERC SATA RAID
PM, Stefano Nichele
> wrote:
> >
> > On Tue, Jan 6, 2009 at 7:45 PM, Scott Marlowe
> > wrote:
> >>
> >> I concur with Merlin you're I/O bound.
> >>
> >> Adding to his post, what RAID controller are you running, does it have
> >
On Tue, Jan 6, 2009 at 7:45 PM, Scott Marlowe 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 battery backup, is the cache set to write
> back or write through?
At the moment I don't have such
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 pg_xl
n Moncure wrote:
On Tue, Jan 6, 2009 at 11:50 AM, Stefano Nichele
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
me formatting
deadlock_timeout = 5s
escape_string_warning = off
standard_conforming_strings = on
Cheers and thanks a lot in advance.
Let me know if other info is useful.
Ste
--
Stefano Nichele
Funambol Chief Architect
Funambol :: Open Source Mobile'We' for the Mass Market ::
htt
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
