Re: Postgresql optimisation
От
Denis BUCHER
Тема
Re: Postgresql optimisation
Дата
Msg-id
4AE86C7D.3020205@hsolutions.ch
Ответ на
Re: Postgresql optimisation (Kevin Grittner)
Список
Дерево обсуждения
Postgresql optimisation Denis BUCHER <dbucherml@hsolutions.ch>
Re: Postgresql optimisation Grzegorz Jaśkiewicz <gryzman@gmail.com>
Re: Postgresql optimisation Denis BUCHER <dbucherml@hsolutions.ch>
Re: Postgresql optimisation Grzegorz Jaśkiewicz <gryzman@gmail.com>
Re: Postgresql optimisation "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Postgresql optimisation Denis BUCHER <dbucherml@hsolutions.ch>
Re: Postgresql optimisation Greg Smith <gsmith@gregsmith.com>
Re: Postgresql optimisation Denis BUCHER <dbucherml@hsolutions.ch>
Re: Postgresql optimisation "Dave Dutcher" <dave@tridecap.com>
Re: Postgresql optimisation Matthew Wakeling <matthew@flymine.org>
Re: Postgresql optimisation "Dave Dutcher" <dave@tridecap.com>
Kevin Grittner a écrit : >> And each morning ... all data is INSERTed new > > I recommend VACUUM ANALYZE of the table(s) after this step. Without > that, the first query to read each tuple sets its hint bits and > rewrites it, causing a surprising delay at unpredictable times > (although heavier near the start of the day). Ok great, thanks for the advice, I added it at the end of the process... Denis
В списке pgsql-performance по дате отправления
