Did you know that you can probably change your GROUP BY clause to use a
column ref, rather than repeating the CASE statement:
GROUP BY gmmid, gmmname, divid, divname, feddept, deptname, fedvend,
vendor_name, masterid, master_desc, pageid, oz_description, 13,
price_original, price_owned_retail,
System:
OS: RedHat 7.2
Dual PIII XEON
Mem 512 mg
PG: 7.2
I have what I think is a fairly simple summary query, but it takes 1:55 to
run on just 155k records. The query hits against a single table that I use
for reporting purposes. This table is truncated, refreshed, reindexed, and
vacuum analy
