agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedRe: SQL Interface (and more)
8+ messages / 8 participants
[nested] [flat]
* Re: SQL Interface (and more)
@ 1970-01-01 00:00 Thomas Krebs <krebs@faps.uni-erlangen.de>
parent: V.Grabner <zen@zen.gklw.co.at>
1 sibling, 0 replies; 8+ messages in thread
From: Thomas Krebs @ 1970-01-01 00:00 UTC (permalink / raw)
To: V.Grabner <zen@zen.gklw.co.at>; +Cc: ucb-postgres
> We would also be very interested in it.
>
> There are also a few things:
>
> We are using postgres on 2 different platforms (Linux + SunOs)
> here for a about a year, have it in CVS an we've it patched a lot.
>
I have also a number of patches done, I could commit.
> (minor bugs, changes (like "copy to,from"), stability enhancements, etc)
>
> We also have a list of "don't use" here, like
>
> hash indices -> break postgres (reproducable)
> the abstime type -> only seem to work without DST
> some array statements -> make the backend core-dump
> records > 8K data -> destroy the database with post mortem warning
> etc ..
>
> and we also extented some #defines like NBACKENDS and stuff for
> large scale databases.
>
> The question is:
>
> Are there enough people interrested to do a (public) project kind of like
> Postgres95, where we could fix some major problems , extend the monster and
> add the fault tolerance needed for normal use ?
>
Maybe an group could be built to manage a central source repository, where
hackers could send their patches to, and maybe an active developers group
is growing out of that.
Opinions???
Thomas
--
Thomas Krebs
Department for Manufacturing Automation and Production Systems FAPS
University of Erlangen
Egerlandstr. 7-9
91058 Erlangen
Tel.: +49 (0)9131/85-8740
Fax: +49 (0)9131/302528
http://www.faps.uni-erlangen.de:1200/persons/krebs.html
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/
^ permalink raw reply [nested|flat] 8+ messages in thread
* SQL Interface
@ 1995-04-26 18:18 Ajay V. Gupte <agupte@mart.saic.com>
0 siblings, 0 replies; 8+ messages in thread
From: Ajay V. Gupte @ 1995-04-26 18:18 UTC (permalink / raw)
To: ucb-postgres
Hi..
I am interested in a SQL interface to Postgres instead of the PostQuel
included with the package. Does anybody know of such a layer on the Net,
which can be modified to fit Postgres. Thanks.
-Ajay V. Gupte
agupte@mart.saic.com
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: SQL Interface
@ 1995-04-26 19:47 Andrew K. Yu <andrew@postgres.Berkeley.EDU>
0 siblings, 0 replies; 8+ messages in thread
From: Andrew K. Yu @ 1995-04-26 19:47 UTC (permalink / raw)
To: agupte@mart.saic.com; +Cc: andrew@postgres.Berkeley.EDU; ucb-postgres
> I am interested in a SQL interface to Postgres instead of the PostQuel
> included with the package. Does anybody know of such a layer on the Net,
> which can be modified to fit Postgres. Thanks.
There is an SQL-version of Postgres called Postgres95. Postgres95 is
derived from the last official release (4.2) of POSTGRES. We replace
Postquel with SQL and also remove some features that do not work. The
code size has been reduced by 25% and it runs about 30-50% faster compared
with v4.2 (on the Wisconsin Benchmark).
Unfortunately, this is a pet project of mine and Jolly Chen and we don't have
a scheduled release date. However, if anyone is interested, we will be
happy to provide a you copy.
Postgres95 has been tested on Alpha (OSF 2.1, 3.0), DECStation (Ultrix 4.4),
SPARC (SunOS 4.1.3), SPARC (Solaris 2.4), HP 9000/700 (HPUX 9.0). An NT
port is in the works.
-andrew
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: SQL Interface
@ 1995-04-27 03:53 Robert J Carter <rjc@oghma.synapse.net>
0 siblings, 0 replies; 8+ messages in thread
From: Robert J Carter @ 1995-04-27 03:53 UTC (permalink / raw)
To: andrew@postgres.Berkeley.EDU; +Cc: andrew@postgres.Berkeley.EDU; ucb-postgres
>>There is an SQL-version of Postgres called Postgres95. Postgres95 is
>>derived from the last official release (4.2) of POSTGRES. We replace
>>Postquel with SQL and also remove some features that do not work. The
>>code size has been reduced by 25% and it runs about 30-50% faster compared
>>with v4.2 (on the Wisconsin Benchmark).
>>
>>Unfortunately, this is a pet project of mine and Jolly Chen and we don't have
>>a scheduled release date. However, if anyone is interested, we will be
>>happy to provide a you copy.
I would dearly love to get my hands on that one - I'm running Linux, and am
willing to do the port.
--
Robert J Carter Oghma Systems
Ottawa, Ontario, Canada FAX: +1 613 231.4732
rjc@oghma.synapse.net rjc@oghma.ocunix.on.ca
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: SQL Interface
@ 1995-04-27 08:32 Richard Taylor <rjt@rivers.dra.hmg.gb>
0 siblings, 1 reply; 8+ messages in thread
From: Richard Taylor @ 1995-04-27 08:32 UTC (permalink / raw)
To: ucb-postgres
>
> > I am interested in a SQL interface to Postgres instead of the PostQuel
> > included with the package. Does anybody know of such a layer on the Net,
> > which can be modified to fit Postgres. Thanks.
>
> There is an SQL-version of Postgres called Postgres95. Postgres95 is
> derived from the last official release (4.2) of POSTGRES. We replace
> Postquel with SQL and also remove some features that do not work. The
> code size has been reduced by 25% and it runs about 30-50% faster compared
> with v4.2 (on the Wisconsin Benchmark).
>
> Unfortunately, this is a pet project of mine and Jolly Chen and we don't have
> a scheduled release date. However, if anyone is interested, we will be
> happy to provide a you copy.
>
> Postgres95 has been tested on Alpha (OSF 2.1, 3.0), DECStation (Ultrix 4.4),
> SPARC (SunOS 4.1.3), SPARC (Solaris 2.4), HP 9000/700 (HPUX 9.0). An NT
> port is in the works.
>
> -andrew
>
I for one would be very interested in taking a look at this.
Richard
------------------------------
Richard Taylor, N129, DRA Malvern, St Andrews Rd, Malvern, Worcs. WR14 3PS. UK.
Tel: +44 1684 896028; Fax: +44 1684 894303; Email: rjt@rivers.dra.hmg.gb
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: SQL Interface (and more)
@ 1995-04-27 15:11 V.Grabner <zen@zen.gklw.co.at>
parent: Richard Taylor <rjt@rivers.dra.hmg.gb>
0 siblings, 2 replies; 8+ messages in thread
From: V.Grabner @ 1995-04-27 15:11 UTC (permalink / raw)
To: ucb-postgres
> > Postgres95 has been tested on Alpha (OSF 2.1, 3.0), DECStation (Ultrix 4.4),
> > SPARC (SunOS 4.1.3), SPARC (Solaris 2.4), HP 9000/700 (HPUX 9.0). An NT
> > port is in the works.
We would also be very interested in it.
There are also a few things:
We are using postgres on 2 different platforms (Linux + SunOs)
here for a about a year, have it in CVS an we've it patched a lot.
(minor bugs, changes (like "copy to,from"), stability enhancements, etc)
We also have a list of "don't use" here, like
hash indices -> break postgres (reproducable)
the abstime type -> only seem to work without DST
some array statements -> make the backend core-dump
records > 8K data -> destroy the database with post mortem warning
etc ..
and we also extented some #defines like NBACKENDS and stuff for
large scale databases.
The question is:
Are there enough people interrested to do a (public) project kind of like
Postgres95, where we could fix some major problems , extend the monster and
add the fault tolerance needed for normal use ?
--zen
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Vinzenz Grabner Voice : + 43 1 817 62 30-11
GKL&W GmbH. Fax : + 43 1 817 62 30-17
Schoenbrunnerstr. 179/II/4.St.
A-1120 Vienna/Austria/Europe e-mail : zen@gklw.co.at
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: SQL Interface
@ 1995-04-27 17:45 Daniel Graham <graham@balance.uoregon.edu>
0 siblings, 0 replies; 8+ messages in thread
From: Daniel Graham @ 1995-04-27 17:45 UTC (permalink / raw)
To: ucb-postgres
I would also like to take a look at the SQL version.
I'd be willing to work on a port to Linux.
Dan
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/
^ permalink raw reply [nested|flat] 8+ messages in thread
* Long running time for query
@ 1995-04-27 20:33 Brian Gallew <bg11@eden.as.cmu.edu>
parent: V.Grabner <zen@zen.gklw.co.at>
1 sibling, 0 replies; 8+ messages in thread
From: Brian Gallew @ 1995-04-27 20:33 UTC (permalink / raw)
To: ucb-postgres
The following query take ~588 seconds to run:
retrieve (c.lname, c.fname, count = cust_freq_count(c.id))
from c in Customer
sort by count, lname, fname
where cust_freq_count is defined as
define function cust_freq_count \
(language = "postquel", returntype = int4)\
arg is (int4)\
as "retrieve (count = count{Call.callerrn where Call.callerrn = $1})
Doing the same thing in tclpqx with:
retrieve (c.callerrn) from c in Call sort by callerrn
<retrieve lines, reduce list/produce count values>
retrieve (c.id, c.fname, c.lname) from c in Customer sort by id
<retrieve values, join lists>
takes ~38 seconds. Perhaps I'm stupid, but shouldn't this be faster in the
backend, rather than in a scripting language? If anyone wants to see the
complete code, I=ll be happy to forward it!
=====================================================================
| It's nice to be important, but it's *important* to suck up to the |
| sysadmin -- Me |
=====================================================================
| Finger geek@cmu.edu for my public key. |
=====================================================================
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~1995-04-27 20:33 UTC | newest]
Thread overview: 8+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1995-04-26 18:18 SQL Interface Ajay V. Gupte <agupte@mart.saic.com>
1995-04-26 19:47 Re: SQL Interface Andrew K. Yu <andrew@postgres.Berkeley.EDU>
1995-04-27 03:53 Re: SQL Interface Robert J Carter <rjc@oghma.synapse.net>
1995-04-27 08:32 Re: SQL Interface Richard Taylor <rjt@rivers.dra.hmg.gb>
1995-04-27 15:11 ` V.Grabner <zen@zen.gklw.co.at>
1970-01-01 00:00 ` Thomas Krebs <krebs@faps.uni-erlangen.de>
1995-04-27 20:33 ` Long running time for query Brian Gallew <bg11@eden.as.cmu.edu>
1995-04-27 17:45 Re: SQL Interface Daniel Graham <graham@balance.uoregon.edu>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox