Re: [GENERAL] Great Bridge benchmark results for Postgres, 4 others

[Ned Lilly]

Oh, Dan, I'm not that clever... ;-)

But I *can* tell you that the market leading proprietary RDBMS products we
tested were not IBM, Informix, or Sybase.

Regards,
Ned


Dan Browning wrote:

> > Can you tell us what version of the (ahem) unnamed
> > proprietary products
> > you used? :-). For example if you used version 8i of an unnamed
> > proprietry product, that might be informative :-).
>
> Oh, but even if you can't tell us what version was used, I'm sure you could
> tell us that story about the monster you saw last week.  But which monster
> was it?  Was it the monster that ATE EYEs?  And I remember you once said
> there was a second monster, could you describe it as well?

Re: [GENERAL] Great Bridge benchmark results for Postgres, 4 others

[Ned Lilly]

Hi Adrian,

We only used the released versions of each database.  We'd be happy to run
the tests again when MySQL 3.23 is official, or when Interbase ships a
real ODBC driver for 6.0 for that matter.

Regards,
Ned

Adrian Phillips wrote:

> It would have been more interesting if MySQL 3.23 had been tested as
> this has reached what seems to be a fairly stable beta and seems to
> perform some operations significantly faster than 3.22 and I believe
> may scale somewhat better as well. Of course it may not be so
> interesting for most PostgreSQL users :-)
>
> Sincerely,
>
> Adrian Phillips
>
> --
> Your mouse has moved.
> Windows NT must be restarted for the change to take effect.
> Reboot now?  [OK]

Re: [GENERAL] Re: Great Bridge benchmark results for Postgres, 4 others

[Ned Lilly]

Mark Kirkwood wrote:

> In a related vein, is it possible that any relevant database parameter settings 
>might be
> published to help folk get the best out of their Postgresql systems ? ( apologies if 
>they are
> there and I missed them )

Hi Mark, here's some more info from the lead engineer on the project for Xperts, 
Richard Brosnahan
(cc'ed here).  Please feel free to contact him directly.

--

With PostgreSQL, we increased the size of the cache, and increased the
number of simultaneous users. We did this by starting the database with a
command that included parameters for this purpose. Out of the box,
PostgreSQL is very conservative with resource use, and thus only allows 32
simultaneous connections. Increasing the number of simultaneous users
requires an increase in cache size. This boost in cache size also boosts
performace by a small margin.

We also executed a process called "vacuum analyze" after loading the tables,
but before the test. This process optimizes indexes and frees up disk space
a bit. The optimized indexes boost performance by some margin.

Re: [GENERAL] Great Bridge benchmark results for Postgres, 4 others

[Ned Lilly]

Doh!  Sorry, I didn't cc Richard Brosnahan after all.  He's at
<[EMAIL PROTECTED]>


Ned Lilly wrote:

> Hi Jeff,
>
> > i haven't played with interbase yet, but my understanding is they have
> > two types of server -- the "classic" (process per connection?) and a
> > "superserver" (multithreaded).  i'm guessing the multithreaded is faster
> > (why bother with the added complexity if it isn't?)  so which version
> > did you run this test against?
>
> Classic.  Superserver didn't work with the ODBC driver.  Richard Brosnahan,
> the lead engineer on the project at Xperts, could connect, but could not
> successfully build tables and load them due to SQL errors.  Feel free to
> contact him directly (he's cc'ed here).

Re: [GENERAL] Great Bridge benchmark results for Postgres, 4 others

[Ross J. Reedstrom]

On Tue, Aug 15, 2000 at 12:21:25PM -0400, Ned Lilly wrote:
> Oh, Dan, I'm not that clever... ;-)
> 
> But I *can* tell you that the market leading proprietary RDBMS products we
> tested were not IBM, Informix, or Sybase.
> 

And in reply to the MySQL version comment/question, Ned said:
 "We only used the released versions of each database."

I took that to mean they used the latest released version of each
database.  One thing I couldn't deduce: which operating system where the
commercial RDBMs run on top of? NT for one of them, for sure, but the
other can probably run on either of the quoted OSs. If it was run on NT,
we might be seeing the linux vs. NT effect.

Ross
-- 
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]> 
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005

[GENERAL] Tuning PostgreSQL to use more RAM...

[Steve Wolfe]

> Actually, more RAM would permit you to increase both the -B parameters as
> well as the -S one ... which are both noted for providing performance
> increases ... -B more on repeative queries and -S on anything involving
> ORDER BY or GROUP BY ...

  For a while now, I've been meaning to investigate how to get PostgreSQL to
take advantage of the RAM in our machine.  It has 512 megs, and most of the
time, about 275-400 megs of it simply go to disk cache & buffer, as nothing
else wants it.  Occasionally, we'll only have 250-300 megs of disk cache.
: )

   While I don't mind disk cache, I feel that we could get better
performance by letting postgres use another hundred megs or so, especially
since our entire /usr/local/pgsql/base directory has only 134 megs of data.
We're currently starting the postmaster with "-B 2048".  The machine has 4
Xeon processors, and 5 drives in the RAID array, so we do have a small bit
of CPU power and disk throughput.  Any suggestions or pointers are welcome.

steve

[GENERAL] Interval examples

[George Robinson II]

Could someone please send me some examples of the interval data type? 
For example, what should the data look like in order to do and insert? 
If I have two iso time stamps, how can I insert them into the interval
datatype?  What are some ways to format the output of an interval type?

Note: When working in perl, I have found the "Perl Cookbook" the most
valuable asset I have.  I think we should get together and produce a web
site where people can submit various type of code involving postgres, so
that newbies (such as myself) have lots of material to learn from.  I'll
have plenty of examples to submit when I'm done with this project.  And
I'd do it myself, but I'm not really a web guy.

Thanks for the help

-g2

Re: [GENERAL]

[Lee Johnson]

just wondering is postgresq a program that will allow similar things as
does microsofts's access..i use access for my current database for
company..

cuz i've noticed in the description things like "server"..which i'm
not on i'm end user of linux looking for  good database for use in linux
to switch over from using access..

thanks
lee

Re: [GENERAL]

[Lamar Owen]

Lee Johnson wrote:
> just wondering is postgresq a program that will allow similar things as
> does microsofts's access..i use access for my current database for
> company..
 
> cuz i've noticed in the description things like "server"..which i'm
> not on i'm end user of linux looking for  good database for use in linux
> to switch over from using access..

PostgreSQL comes with a nice front end called pgaccess that will do most
if not all of what you need under linux.  You will be setting it up
client-server -- just having the client and the server on the same
machine.

--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

Re: [GENERAL]

[Trond Eivind Glomsrød]

Lee Johnson <[EMAIL PROTECTED]> writes:

> cuz i've noticed in the description things like "server"..which i'm
> not on i'm end user of linux looking for  good database for use in linux
> to switch over from using access..

postgresql is more of a competitor to Microsoft's SQL server than
Microsoft Access. It's a server, and doesn't have the equivalent GUI
functionality of Access.

-- 
Trond Eivind Glomsrød
Red Hat, Inc.

[GENERAL] PostgreSQL benchmark

[Paulo Henrique Baptista de Oliveira]

Can any one comment on this:
http://www.newsalert.com/bin/story?StoryId=CozDUWbKbytiXnZy&FQ=Linux&Nav=na-search-&StoryTitle=Linux

[GENERAL] bytea question

[mikeo]

hi all,
   in the pg_trigger table the tgargs column is defined
as type "BYTEA".  i can split this up in perl, once
retrieved, but can't figure out how to "substring"
it in sql.  is there an SQL way to select pieces of
a column of this type?  

any help is appreciated,

mikeo

Re: [GENERAL] bytea question

[mjp]

Try

substr(text,int4) or
substr(text, int4, int4)

For example,


% select substr('hi there',4,3);
 substr 

 the
(1 row)

Morey Parang
ORNL

On Tue, Aug 15, 2000 at 03:34:27PM -0400, mikeo wrote:
> hi all,
>in the pg_trigger table the tgargs column is defined
> as type "BYTEA".  i can split this up in perl, once
> retrieved, but can't figure out how to "substring"
> it in sql.  is there an SQL way to select pieces of
> a column of this type?  
> 
> any help is appreciated,
> 
> mikeo

[GENERAL] pg_dumpall problems

[g]

I need to know how to cast types. Here's my basic problem:
I'm trying to:

update products set list_price = gsa_price * 1.1 where list_price =
gsa_price;

The error I get back is:

ERROR:  Unable to identify an operator '*' for types 'numeric' and
'float8' You will have to retype this query using an explicit cast

So, I'm assuming that I need to cast the value 1.1 as a numeric so that I
will be multiplying a numeric times a numeric. 

Then I realized I had no idea what the syntax to do the cast was. 

Thanks for info


-
Water overcomes the stone;
Without substance it requires no opening;
This is the benefit of taking no action.
Lao-Tse

Brian Knox
Senior Systems Engineer
[EMAIL PROTECTED]

[GENERAL] accessing field properties

[Campbell, Scott]

Hi,

I'm wondering if it is possible to access the properties of an attribute?
i.e. if a given field is a foreign key or primary key, or if it is integer
or varchar, etc.

Is it possible to do this? I know postgres stores all of its informations in
other tables, i.e. pg_tables etc, so is this information available in one of
those tables?

What I'm ultimatly trying to do is grab this information through a web/perl
interface using DBI and use it to construct the webpage.

Thanks
Scott Campbell

Re: [GENERAL] bytea question

[mikeo]

thanks anyway but that doesn't work.  i should've mentioned that i'd
already tried that in SQL.  my apologies.  


tig4=# \d x
  Table "x"
 Attribute | Type  | Modifier
---+---+--
 tgargs| bytea |

tig4=# select substr(tgargs,1,5) from x;
ERROR:  Function 'substr(bytea, int4, int4)' does not exist
 Unable to identify a function that satisfies the given argument types
 You may need to add explicit typecasts

tig4=# select substr(tgargs::text,1,5) from x;
ERROR:  Cannot cast type 'bytea' to 'text'

and other things like varchar, etc.  

tig4=# select * from x;
tgargs
--
 fk_uste_wu_id\000us_states\000web_users\000UNSPECIFIED\000wu_id\000wu_id\000
 fk_uste_wu_id\000us_states\000web_users\000UNSPECIFIED\000wu_id\000wu_id\000
 fk_uste_wu_id\000us_states\000web_users\000UNSPECIFIED\000wu_id\000wu_id\000

what i'm looking to do here is to get the table names and column names out
using sql.  i can do it in perl with a split command on '\' but was curious
as to how to "SQL" split up a BYTEA type field.

mikeo


At 04:38 PM 8/15/00 -0400, [EMAIL PROTECTED] wrote:
>Try
>
>substr(text,int4) or
>substr(text, int4, int4)
>
>For example,
>
>
>% select substr('hi there',4,3);
> substr 
>
> the
>(1 row)
>
>Morey Parang
>ORNL

[GENERAL] Error with PostgreSQL - IMP

[Racchumí]

Hello.

I'm using PostgreSQL 7.0.2 with webmail IMP, but have the follow error :

Warning: Unable to connect to PostgresSQL server: Sorry, too many
clients already in ./lib/db.pgsql on line 266

But i'm with only 01 user, the error appear when the user close session and
them wish input other time inmediatley. The error dissapear them of some
minutes. Have references that the error is by the 32 concurrent session by
default of PostgreSQL, but i am testing with 01 user.

Where is the problem?. 

Thank you.


Get free email and a permanent address at http://www.netaddress.com/?N=1

Re: [GENERAL] pg_dumpall problems

[Stephan Szabo]

I believe the standard way is
CAST(1.1 as numeric)

But the following should also work:
1.1::numeric

Stephan Szabo
[EMAIL PROTECTED]

On Tue, 15 Aug 2000, g wrote:

> I need to know how to cast types. Here's my basic problem:
> I'm trying to:
> 
> update products set list_price = gsa_price * 1.1 where list_price =
> gsa_price;
> 
> The error I get back is:
> 
> ERROR:  Unable to identify an operator '*' for types 'numeric' and
> 'float8' You will have to retype this query using an explicit cast
> 
> So, I'm assuming that I need to cast the value 1.1 as a numeric so that I
> will be multiplying a numeric times a numeric. 
> 
> Then I realized I had no idea what the syntax to do the cast was. 

Re: [GENERAL] bytea question

[Stephan Szabo]

Well, I don't think you're going to be able to without resorting to
something other than straight sql (a c function would probably work).

You can get the value of a particular byte using get_byte(bytea,int)
but I can't think of a good way outside of some sort of function to
turn that into a split.

Also, get_byte elogs if the int is outside the range of octets on
the bytea.  I would have expected it to work closer to substr on
text.

Stephan Szabo
[EMAIL PROTECTED]

On Tue, 15 Aug 2000, mikeo wrote:

> thanks anyway but that doesn't work.  i should've mentioned that i'd
> already tried that in SQL.  my apologies.  
> 
> 
> tig4=# \d x
>   Table "x"
>  Attribute | Type  | Modifier
> ---+---+--
>  tgargs| bytea |
> 
> tig4=# select substr(tgargs,1,5) from x;
> ERROR:  Function 'substr(bytea, int4, int4)' does not exist
>  Unable to identify a function that satisfies the given argument types
>  You may need to add explicit typecasts
> 
> tig4=# select substr(tgargs::text,1,5) from x;
> ERROR:  Cannot cast type 'bytea' to 'text'
> 
> and other things like varchar, etc.  
> 
> tig4=# select * from x;
> tgargs
> --
>  fk_uste_wu_id\000us_states\000web_users\000UNSPECIFIED\000wu_id\000wu_id\000
>  fk_uste_wu_id\000us_states\000web_users\000UNSPECIFIED\000wu_id\000wu_id\000
>  fk_uste_wu_id\000us_states\000web_users\000UNSPECIFIED\000wu_id\000wu_id\000
> 
> what i'm looking to do here is to get the table names and column names out
> using sql.  i can do it in perl with a split command on '\' but was curious
> as to how to "SQL" split up a BYTEA type field.
> 
> mikeo
> 
> 
> At 04:38 PM 8/15/00 -0400, [EMAIL PROTECTED] wrote:
> >Try
> >
> >substr(text,int4) or
> >substr(text, int4, int4)
> >
> >For example,
> >
> >
> >% select substr('hi there',4,3);
> > substr 
> >
> > the
> >(1 row)
> >
> >Morey Parang
> >ORNL
> 

Re: [GENERAL] Error with PostgreSQL - IMP

[Stephan Szabo]

I don't have any good ideas, but is it possible that the connections
aren't being properly terminated so the backend is staying open?
After getting the message, try doing a ps on the database machine to see 
how may postgres processes are running.

Stephan Szabo
[EMAIL PROTECTED]

On 15 Aug 2000, Armando Racchumí Piscoya wrote:

> Hello.
> 
> I'm using PostgreSQL 7.0.2 with webmail IMP, but have the follow error :
> 
> Warning: Unable to connect to PostgresSQL server: Sorry, too many
> clients already in ./lib/db.pgsql on line 266
> 
> But i'm with only 01 user, the error appear when the user close session and
> them wish input other time inmediatley. The error dissapear them of some
> minutes. Have references that the error is by the 32 concurrent session by
> default of PostgreSQL, but i am testing with 01 user.
> 
> Where is the problem?. 
> 
> Thank you.
> 
> 
> Get free email and a permanent address at http://www.netaddress.com/?N=1
> 

[GENERAL]regression test failure on initdb

[Darrin Ladd]

Hi,

I am having a little trouble with the runcheck regression testing of the 
compilation that I just performed.  I am running on a Linux Red-Hat 6.2 OS 
and currently have Postgres 6.5.3 running in non-default directories and on 
a non-default port.  I wanted to install Postgres 7.0.2 in the default areas 
and convert over.  I configured the default area and compiled the new 
version.  Then I go to perform the runcheck regression test and it fails on 
the initdb step.  In the initdb.log the error that is provided is:

FATAL: s_lock(20306f80) at spinc:116, stuck spinlock. Aborting

This seems serious, but I have no idea where to start to fix this.  Please 
point me in the right direction if you can.

Thanks!
Darrin

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

Re: [GENERAL] bytea question

[mjp]

Oops! You have to write a function for it.  Here is a
sample quick C function:

typedef struct
{ int   len;
  char  data[1];
} string;

string *byteatostr(bytea *arg)
{
char buf[1024];
int ln,i;
string *res;
ln = VARSIZE(arg) - VARHDRSZ;
memmove(buf, VARDATA(arg), ln);
for(i=0; i < ln; i++)
 if( buf[i] < 32 ) buf[i]='?';

res = (string *) palloc(VARHDRSZ + ln);
memset(res, 0, VARHDRSZ + ln);
res->len = VARHDRSZ + ln;
memmove(res->data, buf, (int) ln);
return res;
}

where all non-printable chars are replaced with '?'. Optionally,
the chars can be escaped (prefixed with '\') - adjusting ln as neccessry.


now you get:

# select byteatostr(col) from test2;

 byteatostr 

 fk_uste_wu_id?us_states?web_users?UNSPECIFIED?wu_id?wu_id?
(1 rows)





On Tue, Aug 15, 2000 at 05:23:38PM -0400, mikeo wrote:
> thanks anyway but that doesn't work.  i should've mentioned that i'd
> already tried that in SQL.  my apologies.  
> 
> 
> tig4=# \d x
>   Table "x"
>  Attribute | Type  | Modifier
> ---+---+--
>  tgargs| bytea |
> 
> tig4=# select substr(tgargs,1,5) from x;
> ERROR:  Function 'substr(bytea, int4, int4)' does not exist
>  Unable to identify a function that satisfies the given argument types
>  You may need to add explicit typecasts
> 
> tig4=# select substr(tgargs::text,1,5) from x;
> ERROR:  Cannot cast type 'bytea' to 'text'
> 
> and other things like varchar, etc.  
> 
> tig4=# select * from x;
> tgargs
> --
>  fk_uste_wu_id\000us_states\000web_users\000UNSPECIFIED\000wu_id\000wu_id\000
>  fk_uste_wu_id\000us_states\000web_users\000UNSPECIFIED\000wu_id\000wu_id\000
>  fk_uste_wu_id\000us_states\000web_users\000UNSPECIFIED\000wu_id\000wu_id\000
> 
> what i'm looking to do here is to get the table names and column names out
> using sql.  i can do it in perl with a split command on '\' but was curious
> as to how to "SQL" split up a BYTEA type field.
> 
> mikeo
> 
> 
> At 04:38 PM 8/15/00 -0400, [EMAIL PROTECTED] wrote:
> >Try
> >
> >substr(text,int4) or
> >substr(text, int4, int4)
> >
> >For example,
> >
> >
> >% select substr('hi there',4,3);
> > substr 
> >
> > the
> >(1 row)
> >
> >Morey Parang
> >ORNL
> 

Re: [GENERAL] bytea question

[mjp]

Oops! You have to write a function for it.  Here is a
sample quick C function:

typedef struct
{ int   len;
  char  data[1];
} string;

string *byteatostr(bytea *arg)
{
char buf[1024];
int ln,i;
string *res;
ln = VARSIZE(arg) - VARHDRSZ;
memmove(buf, VARDATA(arg), ln);
for(i=0; i < ln; i++)
 if( buf[i] < 32 ) buf[i]='?';

res = (string *) palloc(VARHDRSZ + ln);
memset(res, 0, VARHDRSZ + ln);
res->len = VARHDRSZ + ln;
memmove(res->data, buf, (int) ln);
return res;
}

where all non-printable chars are replaced with '?'. Optionally,
the chars can be escaped (prefixed with '\') - adjusting ln as neccessry.


now you get:

# select byteatostr(col) from test2;

 byteatostr

 fk_uste_wu_id?us_states?web_users?UNSPECIFIED?wu_id?wu_id?
(1 rows)


'hope it works for you.

Morey Parang
ORNL

On Tue, Aug 15, 2000 at 05:23:38PM -0400, mikeo wrote:
> thanks anyway but that doesn't work.  i should've mentioned that i'd
> already tried that in SQL.  my apologies.  
> 
> 
> tig4=# \d x
>   Table "x"
>  Attribute | Type  | Modifier
> ---+---+--
>  tgargs| bytea |
> 
> tig4=# select substr(tgargs,1,5) from x;
> ERROR:  Function 'substr(bytea, int4, int4)' does not exist
>  Unable to identify a function that satisfies the given argument types
>  You may need to add explicit typecasts
> 
> tig4=# select substr(tgargs::text,1,5) from x;
> ERROR:  Cannot cast type 'bytea' to 'text'
> 
> and other things like varchar, etc.  
> 
> tig4=# select * from x;
> tgargs
> --
>  fk_uste_wu_id\000us_states\000web_users\000UNSPECIFIED\000wu_id\000wu_id\000
>  fk_uste_wu_id\000us_states\000web_users\000UNSPECIFIED\000wu_id\000wu_id\000
>  fk_uste_wu_id\000us_states\000web_users\000UNSPECIFIED\000wu_id\000wu_id\000
> 
> what i'm looking to do here is to get the table names and column names out
> using sql.  i can do it in perl with a split command on '\' but was curious
> as to how to "SQL" split up a BYTEA type field.
> 
> mikeo
> 
> 
> At 04:38 PM 8/15/00 -0400, [EMAIL PROTECTED] wrote:
> >Try
> >
> >substr(text,int4) or
> >substr(text, int4, int4)
> >
> >For example,
> >
> >
> >% select substr('hi there',4,3);
> > substr 
> >
> > the
> >(1 row)
> >
> >Morey Parang
> >ORNL
> 

Re: [GENERAL] Great Bridge benchmark results for Postgres, 4 others

[Ned Lilly]

"Ross J. Reedstrom" wrote:

> On Tue, Aug 15, 2000 at 12:21:25PM -0400, Ned Lilly wrote:
> > Oh, Dan, I'm not that clever... ;-)
> >
> > But I *can* tell you that the market leading proprietary RDBMS products we
> > tested were not IBM, Informix, or Sybase.
> >
>
> And in reply to the MySQL version comment/question, Ned said:
>  "We only used the released versions of each database."
>
> I took that to mean they used the latest released version of each
> database.  One thing I couldn't deduce: which operating system where the
> commercial RDBMs run on top of? NT for one of them, for sure, but the
> other can probably run on either of the quoted OSs. If it was run on NT,
> we might be seeing the linux vs. NT effect.

One of them ran on NT, the other four ran on Red Hat Linux 6.1.

[GENERAL] Building a library for PG

[Franck Martin]

I'm trying to build a library for PG to add some new types. I have suceeded
to do it with no problems, but I would like to autoconf/automake the
library, so I don't have to hard code the path for resources files,
installation points, etc...

Can anyone provide me with a standard configuration:
Configure.in
Makefile.am
aclocal.m4
acconfig.h

Thanks.

Franck Martin
Database Development Officer
SOPAC South Pacific Applied Geoscience Commission
Fiji
E-mail: [EMAIL PROTECTED]  
Web site: http://www.sopac.org/  

This e-mail is intended for its recipients only. Do not forward this
e-mail without approval. The views expressed in this e-mail may not be
neccessarily the views of SOPAC.

Re: [GENERAL] PostgreSQL benchmark

[David Lloyd-Jones]

: "Paulo Henrique Baptista de Oliveira" <[EMAIL PROTECTED]>

> Can any one comment on this:
>
http://www.newsalert.com/bin/story?StoryId=CozDUWbKbytiXnZy&FQ=Linux&Nav=na-
search-&StoryTitle=Linux

Why would anybody be surprised?

The only possible weak point in PostgreSQL is its academic heritage -- but
Berkeley is not your average ivory tower.

The working style of the PostgreSQL team is the best there is: 1960's~70's
hacker freestyle, and the people involved are from the same good mould. If
they aren't the midnight crew at the 1970 AI Lab, at least they all could
be. And for gravy, it's international and under Canadian leadership. :-)

  -dlj.

[GENERAL] Problems after installing

[J. Mauricio Cuenca H.]

I've had problems after installing PostgreSQL 6.5.3 on Solaris 2.7
The sorce compiled well. but when I try to run the initdb command I get the
following error:

[6:34pm]-machine:/usr/local/pgsql/bin> ./initdb --pglib=/usr/local/pgsql/lib
ld.so.1: pg_id: fatal: libncurses.so.4: open failed: No such file or
directory
Unable to determine a valid username.  If you are running
initdb without an explicit username specified, then there
may be a problem with finding the Postgres shared library
and/or the pg_id utility.

What could be the problem?
Thanks in advance!

J. Mauricio Cuenca H.
[EMAIL PROTECTED]

Re: [GENERAL] Great Bridge benchmark results for Postgres, 4 others

[Chris Bitmead]

Ned Lilly wrote:
> 
> Oh, Dan, I'm not that clever... ;-)
> 
> But I *can* tell you that the market leading proprietary RDBMS products we
> tested were not IBM, Informix, or Sybase.

That's very helpful. Can you also tell us if Proprietry 1 or Proprietry
2 was definitely NOT MS-SQL Server?

> 
> Regards,
> Ned
> 
> Dan Browning wrote:
> 
> > > Can you tell us what version of the (ahem) unnamed
> > > proprietary products
> > > you used? :-). For example if you used version 8i of an unnamed
> > > proprietry product, that might be informative :-).
> >
> > Oh, but even if you can't tell us what version was used, I'm sure you could
> > tell us that story about the monster you saw last week.  But which monster
> > was it?  Was it the monster that ATE EYEs?  And I remember you once said
> > there was a second monster, could you describe it as well?

Re: [GENERAL] pg_dumpall problems

[g]

Thanks. I figured out the CAST later but didn't know the 1.1::numeric
syntax.

-
Water overcomes the stone;
Without substance it requires no opening;
This is the benefit of taking no action.
Lao-Tse

Brian Knox
Senior Systems Engineer
[EMAIL PROTECTED]

On Tue, 15 Aug 2000, Stephan Szabo wrote:

> I believe the standard way is
> CAST(1.1 as numeric)
> 
> But the following should also work:
> 1.1::numeric
> 
> Stephan Szabo
> [EMAIL PROTECTED]
> 
> On Tue, 15 Aug 2000, g wrote:
> 
> > I need to know how to cast types. Here's my basic problem:
> > I'm trying to:
> > 
> > update products set list_price = gsa_price * 1.1 where list_price =
> > gsa_price;
> > 
> > The error I get back is:
> > 
> > ERROR:  Unable to identify an operator '*' for types 'numeric' and
> > 'float8' You will have to retype this query using an explicit cast
> > 
> > So, I'm assuming that I need to cast the value 1.1 as a numeric so that I
> > will be multiplying a numeric times a numeric. 
> > 
> > Then I realized I had no idea what the syntax to do the cast was. 
> 

Re: [GENERAL] Great Bridge benchmark results for Postgres, 4 others

[Ned Lilly]

Er... let me put it this way.  Proprietary 2 prefers to run on Windows NT.


Chris Bitmead wrote:

> That's very helpful. Can you also tell us if Proprietry 1 or Proprietry
> 2 was definitely NOT MS-SQL Server?

Re: [GENERAL] Great Bridge benchmark results for Postgres, 4 others

[Alfred Perlstein]

> Chris Bitmead wrote:
> 
> > That's very helpful. Can you also tell us if Proprietry 1 or Proprietry
> > 2 was definitely NOT MS-SQL Server?

* Ned Lilly <[EMAIL PROTECTED]> [000815 18:59] wrote:
> Er... let me put it this way.  Proprietary 2 prefers to run on Windows NT.

It's oracle??? j/k

You have some people in San Jose at the Expo right?  I was going to head
over to it tomorrow if you do.

-Alfred

[GENERAL] Referential integrity

[George Robinson II]

Hi again.  Still new to databases, and I was wondering if I could get
advice on how to set this up right.  Essentially, I have a table, lets
call it main, in which each row, describes another table in the
database.  I want to set it up so that, dropping the table will also
drop the associated row - or the other way around (which I would
prefer).  How would I go about doing that?

-g2

Re: [GENERAL] Great Bridge benchmark results for Postgres, 4 others

[Chris Bitmead]

Ned Lilly wrote:
> 
> Er... let me put it this way.  Proprietary 2 prefers to run on Windows NT.

The performance is so bad it must be MS-Access :-).

> Chris Bitmead wrote:
> 
> > That's very helpful. Can you also tell us if Proprietry 1 or Proprietry
> > 2 was definitely NOT MS-SQL Server?

[GENERAL] Search (select) options

[Jeff Davis]

I would like to be able to use searches that seem somewhat intelligent.
Can you 'ORDER BY' number of matching 'OR' clauses? For example, someone
searches for "x y z", so I would do "select * from mytable where col1
like '%x%' or col1 like '%y%' or col1 like '%z%';", but I want it to
order by number of matches (so a match of y and z would turn up before a
match of just x).

If anyone has suggestions, or can point me to some reading, I would
really appreciate it. The only thing I can think of is a complicated
application-side program.

Thanks,
Jeff Davis