On Tue, 4 Mar 2008, Ivan Voras wrote:
I'm curious about the math behind this - is ~4000 burst or sustained
rate?
Average, which is not quite burst or sustained. No math behind it, just
looking at a few samples of pgbench data on similar hardware. A system
like this one is profiled at
http
On Tue, 4 Mar 2008, Ivan Voras wrote:
I'm curious about the math behind this - is ~4000 burst or sustained
rate? For common BBU cache sizes (256M, 512M), filling that amount with
data is pretty trivial. When the cache is full, new data can enter the
cache only at a rate at which old data is evacu
Greg Smith wrote:
> On Mon, 3 Mar 2008, alan bryan wrote:
>
>>> pgbench -c 100 -t 1000 testdb
>> tps = 558.013714 (excluding connections establishing)
>>
>> Just for testing, I tried turning off fsync and got:
>> tps = 4061.662041 (excluding connections establishing)
>
> This is odd. ~500 is wha
alan bryan wrote:
> File './Bonnie.2551', size: 104857600
> Writing with putc()...done
> Rewriting...done
> Writing intelligently...done
> Reading with getc()...done
> Reading intelligently...done
> Seeker 1...Seeker 2...Seeker 3...start 'em...done...done...done...
> ---Sequential
On Tue, 4 Mar 2008, alan bryan wrote:
There seems to be something really wrong with disk performance. Here's
the results from bonnie
So input speed is reasonable but write throughput is miserable--<10MB/s.
I'd suggest taking this to one of the FreeBSD lists; this doesn't look
like a Postgre
On Mon, Mar 3, 2008 at 5:11 PM, Greg Smith <[EMAIL PROTECTED]> wrote:
> On Mon, 3 Mar 2008, alan bryan wrote:
>
> >> pgbench -c 100 -t 1000 testdb
>
> > tps = 558.013714 (excluding connections establishing)
> >
> > Just for testing, I tried turning off fsync and got:
>
> > tps = 4061.662041 (exc
On Mon, 3 Mar 2008, alan bryan wrote:
pgbench -c 100 -t 1000 testdb
tps = 558.013714 (excluding connections establishing)
Just for testing, I tried turning off fsync and got:
tps = 4061.662041 (excluding connections establishing)
This is odd. ~500 is what I expect from this test when there
On Mon, Mar 3, 2008 at 4:26 PM, Bill Moran
<[EMAIL PROTECTED]> wrote:
> > > cat /boot/loader.conf
> > kern.ipc.semmni=256
> > kern.ipc.semmns=512
> > kern.ipc.semmnu=256
> >
> > > cat /etc/sysctl.conf
> > kern.ipc.shmall=393216
> > kern.ipc.shmmax=1610612736
>
> I would just set this to 2
"alan bryan" <[EMAIL PROTECTED]> wrote:
>
> I've got a new server and am myself new to tuning postgres.
>
> Server is an 8 core Xeon 2.33GHz, 8GB RAM, RAID 10 on a 3ware 9550SX-4LP w/
> BBU.
>
> It's serving as the DB for a fairly write intensive (maybe 25-30%) Web
> application in PHP. We are
I've got a new server and am myself new to tuning postgres.
Server is an 8 core Xeon 2.33GHz, 8GB RAM, RAID 10 on a 3ware 9550SX-4LP w/ BBU.
It's serving as the DB for a fairly write intensive (maybe 25-30%) Web
application in PHP. We are not using persistent connections, thus the
high max conne
10 matches
Mail list logo
