Thread: 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
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.net128K ISDN from $22.00/mo - 56K Dialup from $16.00/moat Pop4 Networking Online Campground Directory http://www.camping-usa.com Online Giftshop Superstore http://www.cloudninegifts.com ==========================================================================
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 <___/
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, Pennsylvania19026