Re: PostgreSQL PITR - more doubts

От: Kevin Grittner
Тема: Re: PostgreSQL PITR - more doubts
Дата: ,
Msg-id: 4C3AC42802000025000333E6@gw.wicourts.gov
(см: обсуждение, исходный текст)
Ответ на: Re: PostgreSQL PITR - more doubts  (Jayadevan M)
Список: pgsql-performance

Скрыть дерево обсуждения

PostgreSQL PITR - more doubts  (Jayadevan M, )
 Re: PostgreSQL PITR - more doubts  (Jesper Krogh, )
  Re: PostgreSQL PITR - more doubts  (Jayadevan M, )
   Re: PostgreSQL PITR - more doubts  ("Kevin Grittner", )

Jayadevan M <> wrote:

>> Yes, It starts out form "where it needs to". Assuming you
>> did a pg_start_backup() before you did your base backup?
>
> Thanks. I did.
> It uses files like 0000000B00000000000000D9.00000020.backupto get
> the necessary information?

Yeah, since it's a text file, you can easily have a look at what is
stored there.  It's based on when pg_start_backup and pg_stop_backup
were run.

-Kevin


В списке pgsql-performance по дате сообщения:

От: Bruce Momjian
Дата:
Сообщение: Re: Need help in performance tuning.
От: phb07
Дата:
Сообщение: Re: Slow query with planner row strange estimation