| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Mathijs Brands <mathijs(at)ilse(dot)nl> |
| Cc: | Justin Long <justinlong(at)strategicnetwork(dot)org>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Optimizing Query |
| Date: | 2001-03-05 21:45:47 |
| Message-ID: | 200103052145.QAA04808@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Yes.
> On Mon, Mar 05, 2001 at 04:07:57PM -0500, Bruce Momjian allegedly wrote:
> > Have you tried VACUUM ANALYZE and CLUSTER?
>
> I assume CLUSTER still drops all indexes except the one you're clustering
> on?
>
> Mathijs
> --
> It's not that perl programmers are idiots, it's that the language
> rewards idiotic behavior in a way that no other language or tool has
> ever done.
> Erik Naggum
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Justin Long | 2001-03-05 21:59:47 | Re: Optimizing Query |
| Previous Message | Bruce Momjian | 2001-03-05 21:45:37 | Re: random |