From: Miroslav Šulc <miroslav.sulc@startnet.cz>
To: John Arbash Meinel <john@arbash-meinel.com>
Cc: PGSQL mailing list <pgsql-performance@postgresql.org>
Subject: Re: How to read query plan
Date: Sun, 13 Mar 2005 19:10:21 +0100
Message-ID: <4234820D.5080301@startnet.cz> (raw)
In-Reply-To: <423478B1.7080106@arbash-meinel.com>
References: <42345D24.8070104@startnet.cz>
<4234692E.3050802@arbash-meinel.com>
<42347407.2000202@startnet.cz>
<423478B1.7080106@arbash-meinel.com>
John Arbash Meinel wrote:
> How about a quick side track.
> Have you played around with your shared_buffers, maintenance_work_mem,
> and work_mem settings?
I have tried to set shared_buffers to 48000 now but no speedup
(11,098.813 ms third try). The others are still default. I'll see
documentation and will play with the other parameters.
> What version of postgres are you using?
8.0.1
> The above names changed in 8.0,
> and 8.0 also has some perfomance improvements over the 7.4 series.
>
> What is your hardware?
My dev notebook Acer TravelMate 292LMi
$ cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 9
model name : Intel(R) Pentium(R) M processor 1500MHz
stepping : 5
cpu MHz : 1495.485
cache size : 1024 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr mce cx8 sep mtrr pge mca cmov
pat clflush dts acpi mmx fxsr sse sse2 tm pbe est tm2
bogomips : 2957.31
$ cat /proc/meminfo
MemTotal: 516136 kB
MemFree: 18024 kB
Buffers: 21156 kB
Cached: 188868 kB
SwapCached: 24 kB
Active: 345596 kB
Inactive: 119344 kB
HighTotal: 0 kB
HighFree: 0 kB
LowTotal: 516136 kB
LowFree: 18024 kB
SwapTotal: 1004020 kB
SwapFree: 1003996 kB
Dirty: 4 kB
Writeback: 0 kB
Mapped: 343676 kB
Slab: 18148 kB
CommitLimit: 1262088 kB
Committed_AS: 951536 kB
PageTables: 2376 kB
VmallocTotal: 516056 kB
VmallocUsed: 90528 kB
VmallocChunk: 424912 kB
IDE disc.
# hdparm -Tt /dev/hda
/dev/hda:
Timing cached reads: 1740 MB in 2.00 seconds = 870.13 MB/sec
Timing buffered disk reads: 40 MB in 3.30 seconds = 12.10 MB/sec
> Are you testing this while there is load on the
> system, or under no load.
The load is low. This is few seconds after I have run the EXPLAIN ANALYZE.
# cat /proc/loadavg
0.31 0.51 0.33 1/112 6909
> Are you re-running the query multiple times, and reporting the later
> speeds, or just the first time? (If nothing is loaded into memory, the
> first run is easily 10x slower than later ones.)
The times changes only little. First run was about 13 sec, second about
10 sec, third about 11 sec etc.
> Just some background info. If you have set these to reasonable values,
> we probably don't need to spend much time here, but it's just one of
> those things to check.
Sure you are right. I'll try the other parameters.
>
> John
> =:->
>
Miroslav
Attachments:miroslav.sulc.vcf (text/x-vcard, 385B) download
begin:vcard
fn;quoted-printable:Miroslav =C5=A0ulc
n;quoted-printable:=C5=A0ulc;Miroslav
org:StartNet s.r.o.
adr;quoted-printable;quoted-printable:;;Vrchlick=C3=A9ho 161/5;Praha 5;;150 00;=C4=8Cesk=C3=A1 republika
email;internet:miroslav.sulc@startnet.cz
title:CEO
tel;work:+420 257 225 602
tel;cell:+420 603 711 413
x-mozilla-html:TRUE
url:http://www.startnet.cz
version:2.1
end:vcard
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: miroslav.sulc@startnet.cz, john@arbash-meinel.com
Subject: Re: How to read query plan
In-Reply-To: <4234820D.5080301@startnet.cz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox