pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedAre there any performance penalty for opposite edian platform combinations....
2+ messages / 2 participants
[nested] [flat]
* Are there any performance penalty for opposite edian platform combinations....
@ 2006-08-01 05:01 Guoping Zhang <guoping.zhang@nec.com.au>
0 siblings, 1 reply; 2+ messages in thread
From: Guoping Zhang @ 2006-08-01 05:01 UTC (permalink / raw)
To: pgsql-performance
Hello,
I apologize that if the similar questions were already asked and answered
before.....
Here is a go:
a) If we have application clients running on a Solaris 10/SPARC box and
database server running on a Solaris10 X_86 box; further, we have a few
tables, in which we split an integer type of field into several our own
defined bit map segement, upon them, we have a set of logic operation
implemented in our applications, MY question is, could the different edian
scheme (SPARC is a big edian and X_86 is the opposite) possibly slow down
the applcation?
In fact, it is a general question that "Is it a good practice we shall avoid
to run application server and database server on the platform with opposite
edian? or it simply doesn't matter"?
b) Same direction for the question, if using slony-1, if master server is
running on a big edian host but slave is running on a small edian host, are
there any performance loss due to the edian difference?
Thanks in advance for your opinions.
Regards,
Guoping Zhang
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Are there any performance penalty for opposite edian platform combinations....
@ 2006-08-01 12:10 Tom Lane <tgl@sss.pgh.pa.us>
parent: Guoping Zhang <guoping.zhang@nec.com.au>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2006-08-01 12:10 UTC (permalink / raw)
To: guoping.zhang@nec.com.au; +Cc: pgsql-performance
"Guoping Zhang" <guoping.zhang@nec.com.au> writes:
> In fact, it is a general question that "Is it a good practice we shall avoid
> to run application server and database server on the platform with opposite
> edian? or it simply doesn't matter"?
Our network protocol uses big-endian consistently, so there will be some
tiny hit for little-endian machines, independently of what's on the
other end of the wire. I can't imagine you could measure the difference
though.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-08-01 12:10 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-08-01 05:01 Are there any performance penalty for opposite edian platform combinations.... Guoping Zhang <guoping.zhang@nec.com.au>
2006-08-01 12:10 ` Tom Lane <tgl@sss.pgh.pa.us>
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