Re: What is "Postgresql Hot"?

I guess I was confused by this page during my initial google search:
http://pgfoundry.org/projects/pghotbackup/

There is a PgFoundry project for Postgresql Hot Backup, and the
initial google search pointed to various hot backup projects. In the
above URL there is a perl script relating to hot backups.
http://www.google.com/search?q=postgresql+hot

So yeah, I apologize for the confusion.

- Ericson Smith
Developer
http://www.funadvice.com

On 5/21/07, Dave Page <dpage(at)postgresql(dot)org> wrote:
> Ericson Smith wrote:
> > I've not been following up on the list for some time now, and recently
> > re-subscribed. There is some talk of "Postgresql Hot" which appears to
> > be a hot backup solution that may be included in 8.3
>
> What makes you think it's a hot backup utility? HOT is a technique for
> minimizing (or eliminating) index tuple rewrites for frequently updated
> tables, thus dramatically reducing IO (and consequently increasing
> performance) in the right circumstances.
>
> > * How is it different from the current Perl script out there?
>
> I'm not aware of an existing perl script.
>
> > * Can't pg_dump already give us hot backups?
>
> Yes, it can.
>
> Regards, Dave.
>