RE: [GENERAL] How to improve query performance?

1999-02-19 Thread The Hermit Hacker
On Fri, 19 Feb 1999, Jackson, DeJuan wrote: > The only suggestion I have is to do the Sort after you get the data > back, Perl's pretty good at that. > > Let me know what the timings are. I went to the site and it looks like > it only take ~3-5 seconds to get the data to my browser and format

RE: [GENERAL] How to improve query performance?

1999-02-19 Thread Jackson, DeJuan
The only suggestion I have is to do the Sort after you get the data back, Perl's pretty good at that. Let me know what the timings are. I went to the site and it looks like it only take ~3-5 seconds to get the data to my browser and format it. -DEJ > -Original Message- > I di

Re: [GENERAL] GIS/GPS Experiences with pgsql?

1999-02-19 Thread Jeff Hoffmann
> Actually, it's just text. Here's a sample record: > > 10003 43140280 B Smallwood Road A31 13131891899301893018 9501 9501 227 > 222 -82521645+33638976 -82528956+33639940 > > ...the CD-ROM "database" is about 600MB. i never looked at the tiger that was that old, but i know that the new ones f

Re: [GENERAL] GIS/GPS Experiences with pgsql?

1999-02-19 Thread Peter T Mount
On Thu, 18 Feb 1999, Gregory Maxwell wrote: > On Wed, 17 Feb 1999, Peter T Mount wrote: > > [snip] > > If the TIGER/Line data is raster, and each feature (polygon, line, > > circle, etc) doesn't exceed the block size, then postgresql should be able > > to handle it. > [snip] > > Vector not rast

[GENERAL] How do I increase the maximum record size from 8K ?

1999-02-19 Thread Edmund
I've heard that you can recompile POSTGRES to allow larger than 8K records (tuples). I've looked everywhere and I haven't been able to find any information on it.. Anyone know how to do this or where I should look ? Thanks in advance.. C'ya, Edmund [EMAIL PROTECTED]

[GENERAL] GIS/GPS Experiences with pgsql?

1999-02-19 Thread Bryan Mattern
> > On Wed, 17 Feb 1999, Peter T Mount wrote: > > [snip] > > If the TIGER/Line data is raster, and each feature (polygon, line, > > circle, etc) doesn't exceed the block size, then postgresql should be able > > to handle it. > [snip] > > Vector not raster. Right? Actually, it's just text. He

Re: [GENERAL] Problems with kerberos 4 authenication

1999-02-19 Thread Tom Ivar Helbekkmo
Rodney McDuff <[EMAIL PROTECTED]> writes: > I've compiled postgresql 6.3.2 with kerberos 4 support (using > the KTH-KRB Ebones distribution) on a Alpha running DU4.0D. I've been using KTH Kerberos IV with PostgreSQL for a long time, and it's always been working great, until very recently (