Hi,
i'm trying this too :). My Dump (IN) is about 84 minutes. Now
i'm testing how much time takes it with open_sync :). I'm
anxious about the new results :).
best regards,
pingufreak
Am Freitag, den 10.06.2005, 15:33 +0930 schrieb Steve Pollard:
Hi All,
Not sure if this is correct fix or
Hmmm. In my configuration there are not much more performance:
The Dump-size is 6-7GB on a PIV-3Ghz, 2GB-RAM, 4x10k disks on raid 10
for the db and 2x10k disks raid 1 for the system and the wal-logs.
open_sync:
real79m1.980s
user25m25.285s
sys 1m20.112s
fsync:
real75m23.792s
(including connections
establishing). I'm using Suse Linux 9.3.
I can't see better performance with xfs. :/ Must I enable special
fstab-settings?
Best regards,
Martin
Am Freitag, den 03.06.2005, 10:18 -0700 schrieb J. Andrew Rogers:
On Fri, 3 Jun 2005 09:06:41 +0200
Martin Fandel [EMAIL
Hi,
ah you're right. :) I forgot to symlink the pg_xlog-dir to another
partition. Now it's a bit faster than before. But not faster than
the same installation with reiserfs:
[EMAIL PROTECTED]:~ pgbench -h 127.0.0.1 -p 5432 -c150 -t5 pgbench
starting vacuum...end.
transaction type: TPC-B (sort
Hi @ all,
i have only a little question. Which filesystem is preferred for
postgresql? I'm plan to use xfs (before i used reiserfs). The reason
is the xfs_freeze Tool to make filesystem-snapshots.
Is the performance better than reiserfs, is it reliable?
best regards,
Martin
Aah ok :)
I've set my values now as follow (2GB RAM):
SHMMAX=`cat /proc/meminfo | grep MemTotal | cut -d: -f 2 | awk '{print
$1*1024/3}'`
echo kernel.shmmax=${SHMMAX} /etc/sysctl.conf
SHMALL=`expr ${SHMALL} / 4096 \* \( 4096 / 16 \)`
echo kernel.shmall=${SHMALL} /etc/sysctl.conf
sysctl.conf:
ok i set it to 524288. ;)
Am Freitag, den 03.06.2005, 21:10 +1200 schrieb Mark Kirkwood:
Martin Fandel wrote:
Aah ok :)
I've set my values now as follow (2GB RAM):
SHMMAX=`cat /proc/meminfo | grep MemTotal | cut -d: -f 2 | awk '{print
$1*1024/3}'`
echo kernel.shmmax=${SHMMAX
that problem (that partition is not on
a DB server though).
Alex Turner
netEconomist
On 6/3/05, Martin Fandel [EMAIL PROTECTED] wrote:
Hi @ all,
i have only a little question. Which filesystem is preferred
for
postgresql? I'm plan to use xfs (before i
Hi,
hmmm i don't understand which are the best values for shmmax and shmall.
I've googled around but every site says something different.
I've 2GB of RAM now and set it to:
kernel.shmmax=715827882
kernel.shmall=2097152
Is that value ok for 2GB of RAM?
I've set the shared_buffers in my
Mhz RAM CL2.5
pg_xlog is on sda (raid1 with two 10k discs) and the database on
sdb(raid10 with four 10k discs).
My Linux distribution is Suse Linux 9.3 with postgresql 8.0.1.
best regards,
Martin
Am Donnerstag, den 02.06.2005, 14:50 +0200 schrieb Martin Fandel:
Hi,
hmmm i don't understand
I've forgotten the settings for the pgbench-tests. I use 150 clients
with 5 transactions each.
Am Donnerstag, den 02.06.2005, 15:10 +0200 schrieb Martin Fandel:
Ups,
i'm sorry. i've set the following values:
postgresql.conf:
shared_buffers = 7
effective_cache_size
and will write a feedback
after testing. :)
Thanks a lot. I'm very confusing to tuning the postgresql-db. #:-)
best regards
Martin
Am Dienstag, den 31.05.2005, 13:46 -0500 schrieb John A Meinel:
Martin Fandel wrote:
Hi @ all,
i'm trying to tune my postgresql-db but i don't know
Yes, i think also that this setting should be enabled :).
Am Mittwoch, den 01.06.2005, 11:57 +0200 schrieb Steinar H. Gunderson:
On Wed, Jun 01, 2005 at 07:30:37AM +0200, Cosimo Streppone wrote:
fsync = true
false
Just setting fsync=false without considering the
ived) wals and the database of my hotstandby was
consistent. Is this solution recommended? Or must i use archived wal's with
real system-snapshots?
best regards,
Martin Fandel
14 matches
Mail list logo
