I did post the explain analyze..can you please clarify On Tue, Jun 22, 2010 at 6:10 PM, Joshua D. Drake <jd@xxxxxxxxxxxxxxxxx> wrote: > On Tue, 2010-06-22 at 18:00 -0700, Anj Adu wrote: >> i have several partitions like this (similar size ...similar data >> distribution)..these partitions are only "inserted"..never updated. >> Why would I need to vacuum.. >> > > An explain analyze is what is in order for further diagnosis. > > JD > > >> I can reindex..just curious what can cause the index to go out of whack. >> >> On Tue, Jun 22, 2010 at 4:44 PM, Alvaro Herrera >> <alvherre@xxxxxxxxxxxxxxxxx> wrote: >> > Excerpts from Anj Adu's message of mar jun 22 17:44:39 -0400 2010: >> >> This query seems unreasonable slow on a well-indexed table (13 million >> >> rows). Separate indexes are present on guardid_id , from_num and >> >> targetprt columns. >> > >> > Maybe you need to vacuum or reindex? >> > >> > -- >> > Álvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> >> > The PostgreSQL Company - Command Prompt, Inc. >> > PostgreSQL Replication, Consulting, Custom Development, 24x7 support >> > >> > > -- > PostgreSQL.org Major Contributor > Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 > Consulting, Training, Support, Custom Development, Engineering > > -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
