Lots o' I/O
| От | Clarence Gardner |
|---|---|
| Тема | Lots o' I/O |
| Дата | |
| Msg-id | Pine.LNX.4.44.0302141400210.21703-100000@liberty.sba2.netlojix.net обсуждение исходный текст |
| Ответы |
Re: Lots o' I/O
|
| Список | pgsql-general |
I have a database that was populated about two months ago, and one particular table has begun causing problems. It's got about 20,000 records, all fixed length of about 1 kbytes. If we do any operation that involves a sequential scan of that table (e.g., select count(*)), it now takes about 20 seconds, and according to linux vmstat, reads 275000 disk blocks (275 mbytes). The database is vacuumed each night. I made a copy of the table (create table c2 select * from c), and a count on that table takes much less than a second. Any ideas on what the difference in these tables could be, and how I can avoid this problem? Thanks.
В списке pgsql-general по дате отправления: