Hi,

there is something mixed..

your index is on table1....

Explain Analyze reports about table called: busbase....

Kind Regards,

Misa




2013/3/22 Cindy Makarowsky <cindymakarow...@gmail.com>

> But, I do have an index on Table1 on the state field which is in my group
> by condition:
>
> CREATE INDEX statidx2
>   ON table1
>   USING btree
>   (state COLLATE pg_catalog."default" );
>
> I have vacuumed the table too.
>
> On Fri, Mar 22, 2013 at 5:13 PM, Josh Berkus <j...@agliodbs.com> wrote:
>
>> On 03/22/2013 12:46 PM, Cindy Makarowsky wrote:
>> > I've tried playing around with the settings in the config file for
>> > shared_buffers, work_mem, etc restarting Postgres each time and nothing
>> > seems to help.
>>
>> Well, you're summarizing 55 million rows on an unindexed table:
>>
>> "        ->  Seq Scan on busbase  (cost=0.00..6378172.28 rows=55402728
>> width=7) (actual time=0.004..250046.673 rows=60057057 loops=1)"
>>
>> ... that's where your time is going.
>>
>> My only suggestion would be to create a composite index which matches
>> the group by condition on table1, and vacuum freeze the whole table so
>> that you can use index-only scan on 9.2.
>>
>> --
>> Josh Berkus
>> PostgreSQL Experts Inc.
>> http://pgexperts.com
>>
>>
>> --
>> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org
>> )
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-performance
>>
>
>

Reply via email to