Which version?
Hello, guys:
I am working on adding Postgre support to our multi-threaded benchmarking
tool, which currenlty only support MySQL, and was wondering which version of
pg you would recommend that I use for benchmarks, as well as any special
performance considerations for pg-sql I need to be aware of while doing tests.
The most obvious solution - the 7.0.3 source tarball from the downloads
section on the website did not work because of undefined F_OIDEQ in istrat.c,
and I greped and greped around the source trying to find some insights on it.
My understanding is that F_OIDEQ is a constant that tells the key reading
code how to read a key, or what kind of key it is. Unfortunately, it seems
like the file that defines the constant disappeared from the distribution, or
possibly did not get generated by configure if it was supposed to be
generated. For a while, I thought it could be some mysterious fcntl() option
I had never heard of, but looking at the code it appears otherwise :-)
Anyway, I would appreciate your feedback.
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sasha Pachev <sasha@mysql.com>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA
<___/
Need more information ... specifically what OS are you running? I *just*
built PgSQL 7.0.3 on my freshly installed FreeBSD 4.2-RELEASE box, and it
compiled cleanly ...
On Fri, 26 Jan 2001, Sasha Pachev wrote:
Hello, guys:
I am working on adding Postgre support to our multi-threaded benchmarking
tool, which currenlty only support MySQL, and was wondering which version of
pg you would recommend that I use for benchmarks, as well as any special
performance considerations for pg-sql I need to be aware of while doing tests.The most obvious solution - the 7.0.3 source tarball from the downloads
section on the website did not work because of undefined F_OIDEQ in istrat.c,
and I greped and greped around the source trying to find some insights on it.
My understanding is that F_OIDEQ is a constant that tells the key reading
code how to read a key, or what kind of key it is. Unfortunately, it seems
like the file that defines the constant disappeared from the distribution, or
possibly did not get generated by configure if it was supposed to be
generated. For a while, I thought it could be some mysterious fcntl() option
I had never heard of, but looking at the code it appears otherwise :-)Anyway, I would appreciate your feedback.
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sasha Pachev <sasha@mysql.com>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA
<___/
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
On Friday 26 January 2001 19:04, The Hermit Hacker wrote:
Need more information ... specifically what OS are you running? I *just*
built PgSQL 7.0.3 on my freshly installed FreeBSD 4.2-RELEASE box, and it
compiled cleanly ...
This happened on SuSE 7.0, compiling with gcc 2.95. Maybe I downloaded some
stale corrupted tarball with a file missing - I went to
.http://www.pgsql.com/download/ and just clicked on the top "Download"
button. Where is F_OIDEQ supposed to be defined anyway?
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sasha Pachev <sasha@mysql.com>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA
<___/
I just checked the md5 signature against the one that is online, and they
are exactly the same ... what is at the URL you present is *exactly* the
same as the one that is on ftp.postgresql.org ...
On Fri, 26 Jan 2001, Sasha Pachev wrote:
On Friday 26 January 2001 19:04, The Hermit Hacker wrote:
Need more information ... specifically what OS are you running? I *just*
built PgSQL 7.0.3 on my freshly installed FreeBSD 4.2-RELEASE box, and it
compiled cleanly ...This happened on SuSE 7.0, compiling with gcc 2.95. Maybe I downloaded some
stale corrupted tarball with a file missing - I went to
.http://www.pgsql.com/download/ and just clicked on the top "Download"
button. Where is F_OIDEQ supposed to be defined anyway?--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sasha Pachev <sasha@mysql.com>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA
<___/
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
This happened on SuSE 7.0, compiling with gcc 2.95. Maybe I downloaded some
stale corrupted tarball with a file missing - I went to
.http://www.pgsql.com/download/ and just clicked on the top "Download"
button. Where is F_OIDEQ supposed to be defined anyway?
here: src/backend/utils/fmgr.h:#define F_OIDEQ 184
and here: src/backend/fmgr.h:#define F_OIDEQ 184
and it doesn't appear to be inside of an ifdef either.
Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net
128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
==========================================================================
My guess is that there is some old/other include that is interfering
with our includes. This it the first OID_EQ compile error I can
remember seeing.
This happened on SuSE 7.0, compiling with gcc 2.95. Maybe I downloaded some
stale corrupted tarball with a file missing - I went to
.http://www.pgsql.com/download/ and just clicked on the top "Download"
button. Where is F_OIDEQ supposed to be defined anyway?here: src/backend/utils/fmgr.h:#define F_OIDEQ 184
and here: src/backend/fmgr.h:#define F_OIDEQ 184
and it doesn't appear to be inside of an ifdef either.
Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net
128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
==========================================================================
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026