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
