Re: TRUNCATE TABLE
| От | Alvaro Herrera |
|---|---|
| Тема | Re: TRUNCATE TABLE |
| Дата | |
| Msg-id | 20070801151139.GE6165@alvh.no-ip.org обсуждение исходный текст |
| Ответ на | Re: TRUNCATE TABLE (Adriaan van Os) |
| Список | pgsql-performance |
Дерево обсуждения
TRUNCATE TABLE
(Adriaan van Os,
)
Re: TRUNCATE TABLE (Tom Lane, )
Re: TRUNCATE TABLE (Adriaan van Os, )
Re: TRUNCATE TABLE (Tom Lane, )
Re: TRUNCATE TABLE (Gregory Stark, )
Re: TRUNCATE TABLE (Adriaan van Os, )
Re: TRUNCATE TABLE (Gregory Stark, )
Re: TRUNCATE TABLE (Jean-Max Reymond, )
Re: TRUNCATE TABLE ("Thomas Samson", )
Re: TRUNCATE TABLE (Michael Stone, )
Re: TRUNCATE TABLE (Tom Lane, )
Re: TRUNCATE TABLE (Adriaan van Os, )
Re: TRUNCATE TABLE ("Steinar H. Gunderson", )
Re: TRUNCATE TABLE (Tom Lane, )
Re: TRUNCATE TABLE ("Jim C. Nasby", )
Re: TRUNCATE TABLE (Alvaro Herrera, )
Re: TRUNCATE TABLE ("Pavel Stehule", )
Re: TRUNCATE TABLE ("Jim C. Nasby", )
Re: TRUNCATE TABLE (Tom Lane, )
Re: TRUNCATE TABLE (Adriaan van Os, )
Re: TRUNCATE TABLE (Adriaan van Os, )
Re: TRUNCATE TABLE (Alvaro Herrera, )
Re: TRUNCATE TABLE ("Kevin Grittner", )
Re: TRUNCATE TABLE (Adriaan van Os, )
Re: TRUNCATE TABLE (Decibel!, )
Re: TRUNCATE TABLE (Tom Lane, )
Re: TRUNCATE TABLE (Adriaan van Os, )
Re: TRUNCATE TABLE (Tom Lane, )
Re: TRUNCATE TABLE (Adriaan van Os, )
Re: TRUNCATE TABLE (Tom Lane, )
Re: TRUNCATE TABLE (Gregory Stark, )
Re: TRUNCATE TABLE (Adriaan van Os, )
Re: TRUNCATE TABLE (Gregory Stark, )
Re: TRUNCATE TABLE (Jean-Max Reymond, )
Re: TRUNCATE TABLE ("Thomas Samson", )
Re: TRUNCATE TABLE (Michael Stone, )
Re: TRUNCATE TABLE (Tom Lane, )
Re: TRUNCATE TABLE (Adriaan van Os, )
Re: TRUNCATE TABLE ("Steinar H. Gunderson", )
Re: TRUNCATE TABLE (Tom Lane, )
Re: TRUNCATE TABLE ("Jim C. Nasby", )
Re: TRUNCATE TABLE (Alvaro Herrera, )
Re: TRUNCATE TABLE ("Pavel Stehule", )
Re: TRUNCATE TABLE ("Jim C. Nasby", )
Re: TRUNCATE TABLE (Tom Lane, )
Re: TRUNCATE TABLE (Adriaan van Os, )
Re: TRUNCATE TABLE (Adriaan van Os, )
Re: TRUNCATE TABLE (Alvaro Herrera, )
Re: TRUNCATE TABLE ("Kevin Grittner", )
Re: TRUNCATE TABLE (Adriaan van Os, )
Re: TRUNCATE TABLE (Decibel!, )
Re: TRUNCATE TABLE (Tom Lane, )
Re: TRUNCATE TABLE (Adriaan van Os, )
Adriaan van Os wrote: > Tom Lane wrote: > >> Somehow, autovac is doing something that makes the filesystem go nuts >> every so often, and take an astonishingly long time to create an empty >> file. But autovac itself doesn't create or delete any files, so what's >> up here? >> Also, I was able to reproduce the variability in timing on HPUX and >> Darwin as well as Linux, so we can't put all the blame on ext3. >> (I didn't drill down to the strace level on the other two machines, >> though, so it's possible that there is a different mechanism at work >> there.) > > Any news since this message ? Should I file a bug report ? Were you able to show that turning off autovacuum removes the performance problem? -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
В списке pgsql-performance по дате отправления:
Предыдущее
От: "Luke Lonergan"Дата:
Сообщение: Re: Postgres configuration for 64 CPUs, 128 GB RAM...