Re: Surprise :-(

explain select account, sum(amount) from tbas_transactions where isposted
and trxtype = 'MP' group by account;
psql:xx.txt:1: NOTICE: QUERY PLAN:

Aggregate (cost=10874.64..10889.76 rows=302 width=24)
-> Group (cost=10874.64..10882.20 rows=3025 width=24)
-> Sort (cost=10874.64..10874.64 rows=3025 width=24)
-> Index Scan using trx_trxtype_idx on tbas_transactions
(cost=0.00..10699.78 rows=3025 width=24)

EXPLAIN

Sorry, I do not have an explain from before vacuum analyze.
The table has ~700k rows and indices on account, trxtype and a few other
fields used in other queries.

-----Original Message-----
From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Mihai Gheorghiu <tanethq(at)earthlink(dot)net>
Cc: pgsql-general(at)postgresql(dot)org <pgsql-general(at)postgresql(dot)org>
Date: Thursday, September 05, 2002 4:34 PM
Subject: Re: [GENERAL] Surprise :-(

>On Thu, 5 Sep 2002, Mihai Gheorghiu wrote:
>
>> I ran a vacuum analyze on a database. Now the query I ran vacuum analyze
for
>> takes twice as long, and all the other queries I tested take longer, too.
>> Please help.
>
>What are the queries and explain output for the queries (preferably
>including the old state if you have explain from that as well).
>