Re: Optimizing Query - Mailing list pgsql-sql

From Justin Long
Subject Re: Optimizing Query
Date
Msg-id 5.0.2.1.0.20010305164223.035efe70@mail.strategicnetwork.org
Whole thread Raw
In response to Re: Optimizing Query  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-sql
Does that mean that if you have 3 indexes on a table and you cluster one, it deletes the other 2?<br /><br /> At 04:45
PM3/5/2001 -0500, you wrote:<br /><blockquote cite="cite" class="cite" type="cite">Yes.<br /><br /> > On Mon, Mar
05,2001 at 04:07:57PM -0500, Bruce Momjian allegedly wrote:<br /> > > Have you tried VACUUM ANALYZE and
CLUSTER?<br/> > <br /> > I assume CLUSTER still drops all indexes except the one you're clustering<br /> >
on?<br/> > <br /> > Mathijs<br /> > -- <br /> > It's not that perl programmers are idiots, it's that the
language<br/> > rewards idiotic behavior in a way that no other language or tool has<br /> > ever done.<br />
>                                                    Erik Naggum<br /> > <br /><br /><br /> -- <br />   Bruce
Momjian                       |  <a eudora="autourl" href="http://candle.pha.pa.us/">http://candle.pha.pa.us</a><br />
 pgman@candle.pha.pa.us               |  (610) 853-3000<br />   +  If your life is a hard drive,     |  830 Blythe
Avenue<br/>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026</blockquote><p><font
face="CourierNew, Courier"><br /> ____________________________________________________________________<br /> Justin
Long                                     Networkfor Strategic Missions<br /> justinlong@strategicnetwork.org 1732 South
ParkCourt<br /><a eudora="autourl"
href="http://www.strategicnetwork.org/">http://www.strategicnetwork.org</a> Chesapeake,VA 23320, USA<br /> Reality
Checke-zine: reality-check-subscribe@yahoogroups.com<br />
____________________________________________________________________<br/> Law: Never retreat. Never surrender. Never
cuta deal with a dragon.<br /> Corollary: No armor? Unclean life? Then do not mess in the affairs <br /> of dragons,
foryou are crunchy and taste good with ketchup.<br /></font> 

pgsql-sql by date:

Previous
From: Boulat Khakimov
Date:
Subject: Extending PostgreSQL Using C
Next
From: Justin Long
Date:
Subject: Re: Optimizing Query