| From: | Martin Boese <boesemar(at)gmx(dot)de> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Slow SELECT on small table |
| Date: | 2010-11-22 08:59:30 |
| Message-ID: | 20101122095930.3e8b1d6c@leno |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi,
I am using Postgresql: 9.01, PostGIS 1.5 on FreeBSD 7.0. I have at
least one table on which SELECT's turn terribly slow from time to time.
This happened at least three times, also on version 8.4.
The table has only ~1400 rows. A count(*) takes more than 70 seconds.
Other tables are fast as usual.
When this happens I can also see my system's disks are suffering.
'systat -vm' shows 100% disk load at ~4MB/sec data rates.
A simple VACUUM does *not* fix it, a VACUUM FULL however does. See the
textfile attached.
My postgresql.conf is untouched as per distribution.
Can someone hint me how I can troubleshoot this problem?
Thanks!
Martin
| Attachment | Content-Type | Size |
|---|---|---|
| postgresql-log.txt | text/plain | 5.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Omar Kilani | 2010-11-22 10:01:54 | Re: Performance under contention |
| Previous Message | Jignesh Shah | 2010-11-22 06:54:50 | Re: Performance under contention |