Re: database bloat,non removovable rows, slow query etc...

Поиск
Список
Период
Сортировка
От Matteo Sgalaberni
Тема Re: database bloat,non removovable rows, slow query etc...
Дата
Msg-id 20060901172829.GX2266@sgala.com
обсуждение исходный текст
Ответ на Re: database bloat,non removovable rows, slow query etc...  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: database bloat,non removovable rows, slow query etc...
Re: database bloat,non removovable rows, slow query
Список pgsql-performance
On Fri, Sep 01, 2006 at 10:43:30AM -0400, Tom Lane wrote:
> Matteo Sgalaberni <sgala@sgala.com> writes:
> > 22 daemons that have a persistent connection to this database(all
> > connection are in "idle"(no transaction opened).
>
> You may think that, but you are wrong.
Ok. I stopped all clients. No connections to this database. Only psql
console. Made vacuum
full/freeze all cominations... again dead rows non removable. Nothing
changed as in production.

this is my postgres config:

http://pastebin.com/781480

I read a lot about bloat tables related to
not appropriate fsm settings... can be the mine a case of
misconfiguration of these parameters?

Thx

Matteo



В списке pgsql-performance по дате отправления:

Предыдущее
От: Guillaume Cottenceau
Дата:
Сообщение: increasing shared buffers: how much should be removed from OS filesystem cache?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: database bloat,non removovable rows, slow query etc...