From: | Vince Vielhaber <vev(at)michvhf(dot)com> |
---|---|
To: | "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu> |
Cc: | Vadim Mikheev <vadim(at)krs(dot)ru>, Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>, (PostgreSQL-development) <hackers(at)postgreSQL(dot)org> |
Subject: | Re: [HACKERS] OR clause status report - working |
Date: | 1998-08-01 01:21:44 |
Message-ID: | XFMail.980731212144.vev@michvhf.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 01-Aug-98 Thomas G. Lockhart wrote:
>> The test machine (actually my desktop) has been running the cvsup'd
>> version since I set ip up a couple of weeks ago. The production
>> machine was running 6.3. The INSTALL file says dumping the db wasn't
>> necessary yet I had to - it wouldn't run without it and complained
>> about the older database. Is dumping going to be required for 6.4?
>
> Of course :)
>
> Also, things like the installation docs are the last to be updated
> before a release since they need to accurately match the actual release.
> Pretty much a waste of time in between...
Ok, that makes real good sense to me. Just something to learn when using
a cvsup'd version as opposed to a release.
>
>> Also are indexes working for floats when the query uses BETWEEN?
>
> Probably. The "BETWEEN" becomes an "AND" clause.
Unfortunately I later found this:
-----
campsites=> explain select name from camps3 where lon = 83.5555;
NOTICE: QUERY PLAN:
Seq Scan on camps3 (cost=822.87 size=1 width=12)
EXPLAIN
campsites=>
-----
I have two or three indexes created for lon on camps3.
create index camps3_lon on camps3 (lon);
create index camps3_lon2 on camps3 (lon, float4_ops);
create index camps3_loc on camps3 (lon, lat);
Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev(at)michvhf(dot)com flame-mail: /dev/null
# include <std/disclaimers.h> TEAM-OS2
Online Searchable Campground Listings http://www.camping-usa.com
"There is no outfit less entitled to lecture me about bloat
than the federal government" -- Tony Snow
==========================================================================
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1998-08-01 05:14:52 | Re: AW: [HACKERS] OR clause status report |
Previous Message | Thomas G. Lockhart | 1998-08-01 01:20:15 | Re: [HACKERS] OR clause status report - working |