Re: [GENERAL] advice on buying sun hardware to run postgres

1999-04-27 Thread Chris Bitmead
Dustin Sallings wrote: Works != works as well as SCSI. I've yet to find an example where IDE works as well as SCSI in real life (vs. benchmarks). My real life scenarios rarely involve telling a machine to be still so we can do a disk read, then again for a disk write. Modern

Re: [GENERAL] advice on buying sun hardware to run postgres

1999-04-27 Thread Maarten Boekhold
Never lost a file to Linux in 5 years. Haha, just lost my home directory this weekend. But then again, I was in win98 when my rabbit chewed through a 220V cable and the whole room went black. Might just have something to do with it (but on the other hand, win98 shouldn't even be touching that

Re: [GENERAL] advice on buying sun hardware to run postgres

1999-04-27 Thread Chris Bitmead
Maarten Boekhold wrote: Never lost a file to Linux in 5 years. Haha, just lost my home directory this weekend. But then again, I was in win98 when my rabbit chewed through a 220V cable and the whole room went black. Might just have something to do with it (but on the other hand, win98

Re: [GENERAL] unknown symbol 'lo_unlink'

1999-04-27 Thread JP Rosevear
Tatsuo Ishii wrote: Subject changed. Hey folks, still looking for a little help on this. I can insert data and (obviously create tables). Further, I've discovered PHP with pg support yields an unknown symbol 'lo_unlink' when Apache tries to load it. Any help/pointers would be really

Re: [GENERAL] PL/pgSQL

1999-04-27 Thread Andy Lewis
Thanks I'll give it a try! Andy On Tue, 27 Apr 1999, [iso-8859-1] José Soares wrote: Andy Lewis ha scritto: How does one compile or add PL/pgSQL if it doesn't already exist? I've searched the DOCS and mailing list and the best that I can come up with is an enable script that

Re: [GENERAL] Desperately Seeking Regular Expression

1999-04-27 Thread Adriaan Joubert
I solved something like this recently in perl. It's not terribly efficient, but it is simple. I'm doing this from memory, so it may need some debugging. Use something along the lines of #!/usr/local/bin/perl while () { @a = split /(\")/; # This gives you a list with some of the items being

[GENERAL] Desperately Seeking Regular Expression

1999-04-27 Thread Thomas Good
Hi all - I am porting a PROGRESS database to PostgreSQL. I've had success previously doing a port - but from FoxPro which allows one to dump data delimited by tabs. Unfortunately, PROGRESS dumps fields delimited by whitespace rather than tabs and I can find no documentation on how to alter

Re: [HACKERS] Re: [GENERAL] unknown symbol 'lo_unlink'

1999-04-27 Thread Tatsuo Ishii
Hey folks, still looking for a little help on this. I can insert data and (obviously create tables). Further, I've discovered PHP with pg support yields an unknown symbol 'lo_unlink' when Apache tries to load it. Any help/pointers would be really appreciated. What kind of

[GENERAL] Speed

1999-04-27 Thread Justin Long
I find that it is actually faster to do a SELECT from a single record set, then fetch each individual row and do additional SELECTS to find additional pieces of data from other databases, rather than to a join between two or three databases for example SELECT ctryid, dirid, notes from

Re: [GENERAL] advice on buying sun hardware to run postgres

1999-04-27 Thread Dustin Sallings
On Tue, 27 Apr 1999, Chris Bitmead wrote: # Modern operating systems don't ask the disk to do something and then # just wait for the answer. That's what interrupts are for. Anyway, modern # disks have caches. You can only cache so much. At some point, you're going to actually want to

RE: [GENERAL] Speed

1999-04-27 Thread Jackson, DeJuan
Use Indexes... -DEJ -Original Message- From: Justin Long [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 27, 1999 11:31 AM To: [EMAIL PROTECTED] Subject: [GENERAL] Speed I find that it is actually faster to do a SELECT from a single record set, then fetch each

RE: [GENERAL] INDEXes and UNIQUES and PRIMARY KEYS

1999-04-27 Thread Jackson, DeJuan
If I have a UNIQUE or PRIMARY KEY clause on my class, does that create a btree or hash index? btree I guess if I have a UNIQUE constraint or PRIMARY KEY at class creation, I don't have to create an index explicitely via CREATE INDEX ? correct -DEJ