Kevin Grittner a écrit :
adrien ducos <aducos@xxxxxxxxxxxxxxxx> wrote:
Kevin Grittner a écrit :
What does this show?:
free -m
total used free shared buffers cached
Mem: 3042 3000 41 0 4 2896
-/+ buffers/cache: 99 2942
Swap: 1983 1 1982
This was while the PostgreSQL server was running and showing
shared_buffers = 512MB? If so, there's something seriously wrong
with your OS.
The first line in vmstat (which is all you get if you run it
without a number) is averages since the OS was booted. That's
not usually very helpful. What does this show?:
vmstat 1
same for vmstat 1 while runing the query
vmstat 1
procs -----------memory---------- ---swap-- -----io---- -system--
r b swpd free buff cache si so bi bo in cs
0 0 1280 45752 4496 2963460 0 0 29 45 0 1
Those look like the sort of useless numbers you get on the *first*
line of vmstat, even with a number. What did a few of the *other*
lines look like while the query was running?
-Kevin
.
They Look exactly the same as the first one, with cache changing form
2963460 to 2961000 so not much difference at all...
So what you say is what I thought, there is something wrong with the OS... we will try to put centos (the same OS as in development) instead of redhat the OS installed by the internet provider and see how it goes. Thanks for your feedback.
Adrien
--
Logo_HBS_mail.jpg
Adrien DUCOS
Analyste développeur
aducos@xxxxxxxxxxxxxxxx <mailto:aducos@xxxxxxxxxxxxxxxx>
www.hbs-research.com <http://www.hbs-research.com/>
+33 (0)9 70 44 64 10
24 rue de l'Est
75020 Paris
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
