Re: wal files on temporary tables

Поиск
Список
Период
Сортировка
От marcelo Cortez
Тема Re: wal files on temporary tables
Дата
Msg-id 20060814232047.88495.qmail@web32109.mail.mud.yahoo.com
обсуждение исходный текст
Ответ на Re: wal files on temporary tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: wal files on temporary tables
Список pgsql-general
Tom

  thanks for to respond quickly, see more below

> marcelo Cortez <jmdc_marcelo@yahoo.com.ar> writes:
> > Then i've  created "normal" tables but the wal
> file
> > generated by this tables grows and grows.
>
> The WAL files shouldn't grow indefinitely unless
> you've got some
> fairly serious problem that is preventing
> checkpoints from occurring.
> Look in the server log file to see if there are any
> error messages
> about that.

 The select as sentence is used for generated
"temporary" or cached tables.

Some tables are very big and generate great quantity
of data, for that reason the wal for this tables
grows.
This information is inutil for propositos of backup
and is useless to keep it.
I explore memcached option or pgmemcache proyect.
http://pgfoundry.org/projects/pgmemcache/
any sugestion are welcomed.


 best regads,
  MDC
>
>             regards, tom lane
>





__________________________________________________
Preguntá. Respondé. Descubrí.
Todo lo que querías saber, y lo que ni imaginabas,
está en Yahoo! Respuestas (Beta).
¡Probalo ya!
http://www.yahoo.com.ar/respuestas


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

Предыдущее
От: Reece Hart
Дата:
Сообщение: Re: text datum VARDATA and strings
Следующее
От: Michael Meskes
Дата:
Сообщение: Re: Connection string