Hi
What is your Postgres-Version and with which programming
language are you connecting to the db?
greetings,
Martin
Am Mittwoch, den 29.06.2005, 11:49 +0200 schrieb Shay Kachlon:
> pgsql-performance@postgresql.org
---(end of broadcast)---
TIP 4
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
user
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
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 o
199-230 (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
>
t3 doesn't, don't know about reiser, I went
> straight back to default after 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,
>
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 |
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.co
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
-
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_bu
nabled)
2GB 266 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,
>
>
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 postgres
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 consider
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
the old (not archived) 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
15 matches
Mail list logo