Skip site navigation (1) Skip section navigation (2)

queries stop using indexes

From: Jonathan Vanasco <postgres(at)2xlp(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: queries stop using indexes
Date: 2007-03-31 22:51:41
Message-ID: 676FEFEB-6894-4747-AF8C-478EFEFB38A6@2xlp.com (view raw or flat)
Thread:
Lists: pgsql-general
I have a table with 15 cols , there is an joint index on 5 of them

there are ~15million records in the table, and it gets heavy  use via  
update & insert

i recently noticed that after a day of use, the index is no longer  
being respected in some/all queries and a seq scan on the table is used

i ran analyze, no change.
i ran vacuum analyze, no change.

i dropped the index, and recreated it -- its now used again.

this happened 3x already this week.

can anyone offer a suggestion?


// Jonathan Vanasco

| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  
- - - - - - - - - - - - - - - -
| FindMeOn.com - The cure for Multiple Web Personality Disorder
| Web Identity Management and 3D Social Networking
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  
- - - - - - - - - - - - - - - -
| RoadSound.com - Tools For Bands, Stuff For Fans
| Collaborative Online Management And Syndication Tools
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  
- - - - - - - - - - - - - - - -



Responses

pgsql-general by date

Next:From: Tom LaneDate: 2007-04-01 07:02:26
Subject: Re: Default value of column not respecting character length or domain restraints.
Previous:From: MaDogDate: 2007-03-31 22:40:56
Subject: PlPg/SQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group