Re: 7.0.2 issues / Geocrawler

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: Tim Perdue <tperdue(at)valinux(dot)com>
Cc: Mike Mascari <mascarm(at)mascari(dot)com>, pgsql-hackers(at)hub(dot)org
Subject: Re: 7.0.2 issues / Geocrawler
Date: 2000-07-12 16:07:10
Message-ID: Pine.BSF.4.21.0007121306500.1325-100000@thelab.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, 12 Jul 2000, Tim Perdue wrote:

> Mike Mascari wrote:
> > Have you VACUUM ANALYZE'd the table(s) in question?
>
> Yes, they've been vacuum analyze'd and re-vaccum analyze'd to death.
> Also added some extra indexes that I don't really need just to see if
> that helps.

what does EXPLAIN <query>; show and what is the QUERY itself that is so
slow?

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 2000-07-12 16:08:31 Re: 7.0.2 issues / Geocrawler
Previous Message The Hermit Hacker 2000-07-12 16:06:36 Re: 7.0.2 issues / Geocrawler