| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - -
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-04-01 07:02:26 | Re: Default value of column not respecting character length or domain restraints. |
| Previous Message | MaDog | 2007-03-31 22:40:56 | PlPg/SQL |