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
       <___/                  

Fri, 26 Jan 2001 14:51:16 -0700
Sasha Pachev <sasha@mysql.com>
Which version?

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


Fri, 26 Jan 2001 22:04:51 -0400 (AST)
The Hermit Hacker <scrappy@hub.org>
Re: Which version?
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
       <___/                  

Fri, 26 Jan 2001 20:21:20 -0700
Sasha Pachev <sasha@mysql.com>
Re: Which version?

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


Sat, 27 Jan 2001 03:19:53 -0400 (AST)
The Hermit Hacker <scrappy@hub.org>
Re: Which version?

> > 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
==========================================================================




Sat, 27 Jan 2001 09:09:15 -0500 (EST)
Vince Vielhaber <vev@michvhf.com>
Re: Which version?
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

Sat, 27 Jan 2001 13:04:41 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Which version?