Re: Speed issues with update
От | Norman Clarke |
---|---|
Тема | Re: Speed issues with update |
Дата | |
Msg-id | 00110213341200.28356@curly обсуждение исходный текст |
Ответ на | Speed issues with update (Lorenz Bateman <lorenz@ivision.co.uk>) |
Ответы |
Re: Speed issues with update
|
Список | pgsql-general |
Lorenz, Have you run VACUUM on the table? Norman On Wednesday 01 November 2000 05:43 am, you wrote: > I'm using 'PostgreSQL 7.0.2 on i386-unknown-freebsdelf4.0, compiled by > cc'. > > The problem is that the following statement takes approx 3hrs on a table > with approx 136,000 records. > > update table_name set state = 10 where pid is null; > > pid is indexed. The result from an explain on the statement is as > follows... > > Seq Scan on table_name (cost=0.00..8668.56 rows=45348 width=310) > > When the query is running, disk io is minimal, but cpu is maxed. > > Can anyone suggest a solution or a way of finding where pg is spending all > the cpu time? > > Thanks > > Loz
В списке pgsql-general по дате отправления: