[HACKERS] Stefan Simkovics' paper and pgsql version 8.1

2005-08-06 Thread Shahbaz
Hi, I would like to use postgresql for a couple of database experiments I've been thinking about. I found Stefan Simkovic's paper "Enhancement of the ANSI SQL Implementation of PostgreSQL." It is a great guide, although I'm wondering: 1. How relevant is this paper now (with release 8.1 in the wor

Re: [HACKERS] Stefan Simkovics' paper and pgsql version 8.1

2005-08-06 Thread Shahbaz
sql.sgml just seems to be an intro to sql/relational. The Simkovics paper is absolutely perfect for someone like me who wants to try some experiments but can't commit too much time! Does any one think time is ripe for an update to the paper??? ;) Actually I always wanted a whole book on postgres

[HACKERS] BITMAP Index support (and other DSS info.)

2002-12-29 Thread Shahbaz Chaudhary
ncial firm and trust me when I say that they spend HUGE amounts of money on software that does nothing more than what postgresql developers could add: ordered set of tuples, link to data streams, memory based tables, etc.) Any way, I hope this isn't considered off-topic :). Shahbaz C.

[HACKERS] java access to the backend (non jdbc)?

2003-02-13 Thread Shahbaz Chaudhary
. Basically some very useful information for admins. I've forgotten most of C, C++ (from college days), but would love to try my hand at such a utility...I'm sure there are others who would like to use java to access such a backend. Any pointers? Shahbaz C.

Re: [HACKERS] java access to the backend (non jdbc)?

2003-02-13 Thread Shahbaz Chaudhary
e DB right on my machine. I guess think of it as a dashboard that constantly displays the db status. Something like 'top' rather than 'ps -ef|grep .'. As far as I understand, JDBC is just a mechanism to connect to a db, execute queries, etc., not get this kind of info. Sha

Re: [HACKERS] [ADMIN] Pseudo-Off-topic-survey: Opinions about future of Postgresql(MySQL)?

2004-08-16 Thread Shahbaz Javeed
o Postgres e.g. what Enrique mentioned (clustering, load balancing, replication etc). I've never dabbled in the internals of postgres before but I'd be willing to lend a hand in any way to get those features into Postgres. Shahbaz Javeed On Fri, 13 Aug 2004 22:29:09 -0400 (EDT), B

Re: [HACKERS] AT TIME ZONE

2004-08-24 Thread Shahbaz Javeed
d. I guess the select syntax would allow storing gmt in both fields but extracting one as local and the other as gmt. Shahbaz On Tue, 24 Aug 2004 10:46:23 -0400, Tom Lane <[EMAIL PROTECTED]> wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > TODO entry? > > * Merge h

Re: [HACKERS] Developers page is down

2004-09-04 Thread Shahbaz Javeed
I've always considered a table definition to be an unordered hash so the concept of putting something in the "middle of a table" from that view doesn't seem to have a point. Just my $0.02 Shahbaz Javeed On Sat, 04 Sep 2004 21:44:24 +0200, Gaetano Mendola <[EMAIL PROTECTED

Re: [HACKERS] compact PostgreSQL

2004-10-09 Thread Shahbaz Javeed
mpile. > > Regards, > Yui > > ---(end of broadcast)--- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match > -- Shahb