agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedRe: SQL Interface (and more)
5+ messages / 5 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; 5+ 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] 5+ messages in thread
* Re: SQL Interface
@ 1995-04-27 08:32 Richard Taylor <rjt@rivers.dra.hmg.gb>
0 siblings, 1 reply; 5+ 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] 5+ 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; 5+ 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] 5+ 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; 5+ 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] 5+ messages in thread
* Re: SQL Interface (and more)
@ 1995-04-28 08:46 Lukas Rosenthaler <rosenth@foto.chemie.unibas.ch>
0 siblings, 0 replies; 5+ messages in thread
From: Lukas Rosenthaler @ 1995-04-28 08:46 UTC (permalink / raw)
To: ucb-postgres; zen@zen.gklw.co.at
>>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 ?
Yes, I would be intersted...
L. Rosenthaler
+----------------------------------------------------------------------------+
| Dr. Lukas Rosenthaler Email: rosenth@foto.chemie.unibas.ch |
| Phone: +41 61 267 3836 (University) |
| Inst. of Phys. Chemistry Phone: +41 61 302 2313 (Cadwork AG) |
| Scientific Photography Lab, |
| University of Basel, Switzerland |
| & |
| Cadwork Informatique SA, Lausanne/Basel |
+----------------------------------------------------------------------------+
==============================================================================
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] 5+ messages in thread
end of thread, other threads:[~1995-04-28 08:46 UTC | newest]
Thread overview: 5+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
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-28 08:46 Re: SQL Interface (and more) Lukas Rosenthaler <rosenth@foto.chemie.unibas.ch>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox