pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedperformance of PostgreSQL on 64 bit MAC OS X G5!
2+ messages / 2 participants
[nested] [flat]
* performance of PostgreSQL on 64 bit MAC OS X G5!
@ 2004-09-24 19:23 Qing Zhao <qzhao@supplyfx.com>
2004-09-26 23:31 ` Re: performance of PostgreSQL on 64 bit MAC OS X G5! Christopher Browne <cbbrowne@acm.org>
0 siblings, 1 reply; 2+ messages in thread
From: Qing Zhao @ 2004-09-24 19:23 UTC (permalink / raw)
To: pgsql-performance; +Cc: Kai Mildenberger <kai@supplyfx.com>; Partha Roy <proy@supplyfx.com>
Hi,
We have been running PostgreSQL 7.3.4 on 64 bit MAC OS X G5 dual
processors with 8GB of RAM for a while.
Lately, we realized that consistently only about 4GB of RAM is used
even when CPUs have maxed out
for postgtres processes and pageouts starts to happen. Here is a
portion of the output from TOP:
MemRegions: num = 3761, resident = 41.5M + 7.61M private, 376M shared
PhysMem: 322M wired, 1.83G active, 1.41G inactive, 3.56G used, 4.44G
free
VM: 14.0G + 69.9M 277034(0) pageins, 1461(0) pageouts
Is it because PostgreSQL 7.3.4 can't take advantage of the 64 bit
hardware or is it something else?
Thanks a lot!
Qing
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: performance of PostgreSQL on 64 bit MAC OS X G5!
2004-09-24 19:23 performance of PostgreSQL on 64 bit MAC OS X G5! Qing Zhao <qzhao@supplyfx.com>
@ 2004-09-26 23:31 ` Christopher Browne <cbbrowne@acm.org>
0 siblings, 0 replies; 2+ messages in thread
From: Christopher Browne @ 2004-09-26 23:31 UTC (permalink / raw)
To: pgsql-performance
Oops! qzhao@supplyfx.com (Qing Zhao) was seen spray-painting on a wall:
> Is it because PostgreSQL 7.3.4 can't take advantage of the 64 bit
> hardware or is it something else?
PostgreSQL has been able to take advantage of 64 bit hardware WHEN THE
OS SUPPORTS IT, for quite a few versions now.
As far as I was aware, Mac OS-X was still deployed as a 32 bit
operating system. Apple's advertising material seems deliberately
ambiguous in this regard; it seems to imply there is no difference
between 32- and 64-bit applications. To wit:
"... This means that 32-bit applications that run on Mac OS X today
will run natively on 64-bit PowerPC G5 Processor-based Macintosh
computers, without the need for recompiling or additional
optimizations."
There are quite likely to be some additional "compiler incantations"
required in order to compile applications as 64 bit apps that will be
able to reference, internally, more than 4GB of RAM.
--
wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','acm.org').
http://www3.sympatico.ca/cbbrowne/sgml.html
Tell a man that there are 400 billion stars, and he'll believe you.
Tell him a bench has wet paint, and he has to touch it.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-09-26 23:31 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-09-24 19:23 performance of PostgreSQL on 64 bit MAC OS X G5! Qing Zhao <qzhao@supplyfx.com>
2004-09-26 23:31 ` Christopher Browne <cbbrowne@acm.org>
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