| From: | Ameet Kini <akini(at)cs(dot)wisc(dot)edu> |
|---|---|
| To: | Postgresql Performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: postgresql performance tuning |
| Date: | 2005-12-06 22:03:22 |
| Message-ID: | Pine.LNX.4.58.0512061546120.22753@karadi.cs.wisc.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
> what evidence do you have that you are suffering index bloat? or are
> you just looking for solutions to problems that don't exist as an
> academic exercise? :-)
Well, firstly, its not an academic exercise - Its very much of a real
problem that needs a real solution :)
I'm running postgresql v8.0 and my problem is that running vacuum on my
indices are blazing fast (upto 10x faster) AFTER running reindex. For a
table with only 1 index, the time to do a vacuum (without full) went down
from 45 minutes to under 3 minutes. Maybe thats not bloat but thats
surely surprising. And this was after running vacuum periodically.
Ameet
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
Ameet
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-12-06 23:45:03 | Re: High context switches occurring |
| Previous Message | David Lang | 2005-12-06 21:57:12 | Re: two disks - best way to use them? |