Re: [GENERAL] newbie Q's

2000-02-18 Thread Ed Loehr
Gary Horton wrote: > > I have newcomer type questions about use PostGreSQL and have been > directed to this mailing list by the site's webmaster. Please feel free > to redirect me if that's appropriate. > > I first wonder if there is a pgsql newgroup or some other type of > archive with FAQ, etc

Re: [GENERAL] problems with memory

2000-02-18 Thread selkovjr
> * Dean Browett <[EMAIL PROTECTED]> [000218 15:55] wrote: > > Hi, > > > > We are running postgres-6.5.3 on a dual pentium 300 machine, 0.5Gb RAM under > > Linux Redhat 6.0 (kernel 2.2.14). The machine we are using sits on a 100Mb > > network and the nics are 3com3c590's. We are also using a DPT

Re: [GENERAL] problems with memory

2000-02-18 Thread Alfred Perlstein
* Dean Browett <[EMAIL PROTECTED]> [000218 15:55] wrote: > Hi, > > We are running postgres-6.5.3 on a dual pentium 300 machine, 0.5Gb RAM under > Linux Redhat 6.0 (kernel 2.2.14). The machine we are using sits on a 100Mb > network and the nics are 3com3c590's. We are also using a DPT Raid > contr

[GENERAL] newbie Q's

2000-02-18 Thread Gary Horton
I have newcomer type questions about use PostGreSQL and have been directed to this mailing list by the site's webmaster. Please feel free to redirect me if that's appropriate. I first wonder if there is a pgsql newgroup or some other type of archive with FAQ, etc. Secondly, I seek an E/R modelin

[GENERAL] problems with memory

2000-02-18 Thread Dean Browett
Hi, We are running postgres-6.5.3 on a dual pentium 300 machine, 0.5Gb RAM under Linux Redhat 6.0 (kernel 2.2.14). The machine we are using sits on a 100Mb network and the nics are 3com3c590's. We are also using a DPT Raid controller in a raid5 configuration set up as 1 logical drive. We are try

Re: [GENERAL] ORDER BY problems

2000-02-18 Thread omid omoomi
hi, As far as I understand,tracking_num is primary key and uniqe! So when you sort the date by a uniqe field their would be no place for other fields to be sort on! May be you are going to sort the data some other way. so I think your query is doing well. Omid Omoomi >From: David Shrewsbury <[E

Re: [GENERAL] RE: postgresql and web transactions

2000-02-18 Thread Manuel Lemos
Hello Lincoln, On 18-Feb-00 05:40:51, you wrote: >About transactions, I find that they're not that useful in a typical web >app, because >1) Many web apps are simple, and don't need transactions, or have simple >work arounds. You mean that applications that require almost read only databases,

[GENERAL] ORDER BY problems

2000-02-18 Thread David Shrewsbury
I cannot seem to get ORDER BY to work properly when I want to sort using two different columns. I have code similar to the following: SELECT tracking_num, username FROM reports WHERE customer='$customer' ORDER BY tracking_num, username This will sort by tracking_num (int4, primary key), but NOT

Re: [GENERAL] RE: postgresql and web transactions

2000-02-18 Thread Lincoln Yeoh
At 10:10 AM 17-02-2000 +0100, Nemeth Miklos wrote: >> And if this isn't too inflamatory a question, where does postgresql stand >> in comparison to MySql and DB2? (both of which aren't free I believe). >> >MySQL does NOT support transaction, which is indispensable for a real >DBMS used as the prim