[GENERAL] Re: Can PostgreSQL be a mail backend?

2001-02-27 Thread Gunnar R|nning
Frank Joerdens <[EMAIL PROTECTED]> writes: > I don't see why it shouldn't work, since 7.1 supports an unlimited row > width. The question is: Why would you want to do that? A filesystem is > always faster than a database, which is usually a very important > consideration with a mailserver (or wer

[GENERAL] Re: Can PostgreSQL be a mail backend?

2001-02-27 Thread Gunnar R|nning
"Morten W. Petersen" <[EMAIL PROTECTED]> writes: > I'm wondering if postgres could be capable of acting as a > mail storage. This would imply storing messages, from > 1KB to > 100MB in size. The expected volume is 4000 > messages a day, and the database may store up to, > lets say, 50 messa

[GENERAL] Re: full text searching

2001-02-08 Thread Gunnar R|nning
Lincoln Yeoh <[EMAIL PROTECTED]> writes: > Sometimes I want it literal too. e.g. I'm searching for car I want car and > nothing else. Of course, you want this as well. > In the end it seems too complex. I'm starting to think it may be better to > keep things literal but fast, and do the smart

[GENERAL] Re: full text searching

2001-02-07 Thread Gunnar R|nning
"Mitch Vincent" <[EMAIL PROTECTED]> writes: > > I've been using a variant of the FTI system in an application, but this is > > far from sufficient when it comes to matching. Speed is OK, but the > quality > > of the results could have been a lot better. > > Really? How are you using it? If it's

[GENERAL] Re: full text searching

2001-02-06 Thread Gunnar R|nning
"Mitch Vincent" <[EMAIL PROTECTED]> writes: > Well, the search engine isn't the database, IMHO. The search "engine" is > your application... The database will go get anything you tell it to, you > just have to know how to tell it and make sure that your application tells > it in the correct way.

[GENERAL] Re: Looking for info on Solaris 7 (SPARC) specific considerations

2001-01-23 Thread Gunnar R|nning
Tom Lane <[EMAIL PROTECTED]> writes: > > sparc_solaris - SUN SPARC on Solaris 2.4, 2.5, 2.5.1 > > After you build PG and test it, send us a port report, and we'll add > Solaris 7 to the list of recently tested platforms. That's how it > works ... > We've had client running pgsql 7.0 on Solari

Re: [GENERAL] Re: JDBC Performance

2001-01-18 Thread Gunnar R|nning
Bruce Momjian <[EMAIL PROTECTED]> writes: > Can you confirm that it is OK now? Your email from October 18th below > seems to indicate it is not correct. Can I get a diff against the > current CVS source that I can apply? Thanks. Sorry for the confusion. It wasn't okay before I left to Keny

Re: [GENERAL] Full text searching?

2000-11-10 Thread Gunnar R|nning
"Poul L. Christiansen" <[EMAIL PROTECTED]> writes: > > I convert the characters - e.g. ø will be converted to ø When I > do a search, i just replace the search string the same way. The only > problem that could arise is when people search for the word "slash", but > I guess you could avoid searc

Re: [GENERAL] Re: [HACKERS] My new job

2000-10-12 Thread Gunnar R|nning
"Adam Lang" <[EMAIL PROTECTED]> writes: > May bad... sometimes it is too easy assuming everything open source is GPL. > > > > correct?, so it can't really be proprietised unless they make an add-on Of course both lincenses can be the basis of propriatery efforts(GPL and Apache(BSD style licens

Re: [GENERAL] Re: [HACKERS] My new job

2000-10-10 Thread Gunnar R|nning
Adam Haberlach <[EMAIL PROTECTED]> writes: > All this whinging about "corperate direction" is really meaningless > unless you are prepared to jump ship or split off in a clone of the > original one. The code is what you do with it. We are all lucky that > it is as good and useful as it is

Re: [GENERAL] Re: [HACKERS] My new job

2000-10-10 Thread Gunnar R|nning
Bruce Momjian <[EMAIL PROTECTED]> writes: > more in voliation of the original plan. > violation ? Or is this just another gap in my knowledge of the English language ? Gunnar

Re: [GENERAL] Re: [HACKERS] My new job

2000-10-10 Thread Gunnar R|nning
"Adam Lang" <[EMAIL PROTECTED]> writes: > I wasn't judging. I was mentioning to others what the concerns probably > were. Also, it isn't a concern of "Company B" taking over. It is of the > possibility of development put in the direction that best benefits of > Company B as opposed to the proj

Re: [GENERAL] Re: JDBC Performance

2000-10-09 Thread Gunnar R|nning
"Keith L. Musser" <[EMAIL PROTECTED]> writes: > I did try out Peter's new JDBC driver on two very simple query-only > applications. It was about 15% slower on one of the apps and 10% faster > on the other, compared with jdbc7.0-1.2.jar. It worked correctly on > both tests. > > Neither is parti

Re: [GENERAL] PostgreSQL encoding question

2000-10-09 Thread Gunnar R|nning
"Anton Kalauzky" <[EMAIL PROTECTED]> writes: > Dear friends, > > I have two PC's with exactly the same configurations - one in my office and > the other at home. They are running RedHat Linux 6.2 and PostgreSQL included > in distribution. The first one I recently installed by upgrading from Li

Re: [GENERAL] FW: URGENT: pgsql on the web server - memory problems....

2000-10-05 Thread Gunnar R|nning
"Nikolay Mijaylov" <[EMAIL PROTECTED]> writes: > Thank for responce. > > the php is installed as CGI-BIN executable. I think "keep the connections > open" option is not applicable here. I do this because every user works > under its own uid and gid, instead all under "nobody". > > i dont have a

Re: [GENERAL] FW: URGENT: pgsql on the web server - memory problems....

2000-10-05 Thread Gunnar R|nning
"Nikolay Mijaylov" <[EMAIL PROTECTED]> writes: > The problem is that PHP is auto killing after a while (1-2 min), but the pos > tgres backend process stay (and works about 2 or many more hours). Soon all > Linux is filled with 64 postgres processes, free memory is 0 and Linux, free > ze :) > Th

Re: [GENERAL] Re: JDBC Performance

2000-09-29 Thread Gunnar R|nning
"Keith L. Musser" <[EMAIL PROTECTED]> writes: > Gunnar, > > Your new JDBC driver (postgresql.jar, 29-Sept-2000, 14:47, 187K) caused > the following error. > > > SELECT host, port FROM Servers WHERE PID=1; > Bad Integer int4 > at org.postgresql.jdbc2.ResultSet.getInt(ResultSet.java:261) > at o

Re: [GENERAL] Re: JDBC Performance

2000-09-29 Thread Gunnar R|nning
"Keith L. Musser" <[EMAIL PROTECTED]> writes: > Gunnar, > > Your new JDBC driver (postgresql.jar, 29-Sept-2000, 14:47, 187K) caused > the following error. > Thanks, I will look into the problem. The regression tests that Peter Mount talking about would have been nice to have to catch things li

Re: [GENERAL] Re: JDBC Performance

2000-09-27 Thread Gunnar R|nning
Tim Kientzle <[EMAIL PROTECTED]> writes: > > I'm finding that ... my CPU spends about 60% of the time in JDBC, and about > > 40% of the time in the postmaster backend. > > (Each query takes 2 msec on my machine, RH Linux 6.2, 733 MHz Intel, w/ > > lots of memory.) > > This doesn't sound too bad