Re: Losing data

Поиск
Список
Период
Сортировка
От Robert Treat
Тема Re: Losing data
Дата
Msg-id 200806200026.16387.xzilla@users.sourceforge.net
обсуждение исходный текст
Ответ на Re: Losing data  (Garry Saddington <garry@schoolteachers.co.uk>)
Ответы Re: Losing data  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Losing data  (Garry Saddington <garry@schoolteachers.co.uk>)
Список pgsql-general
On Thursday 19 June 2008 14:06:38 Garry Saddington wrote:
> > In any case, however, if PostgreSQL reported the transaction complete and
> > the machine didn't experience any hardware problems (like sudden power or
> > disk failure), I would certainly not suspect PostgreSQL as the source of
> > the problem.
>
> What has happened to the reports then? I have used this combination of Zope
> and Postgres for 5 years with no problems like this before and we have
> written one complete set of reports on this server in the past 6 weeks. The
> problem seems to have started last friday, when reports started to go
> missing.

Out of curiosity, what is your vacuum strategy?

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

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

Предыдущее
От: "Mark Wilden"
Дата:
Сообщение: Re: Vacuum and inserts
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Losing data