Thread: What is "Postgresql Hot"?
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 * How is it different from the current Perl script out there? * Can't pg_dump already give us hot backups? Regards - Ericson Smith Developer http://www.funadvice.com
esconsult1@gmail.com ("Ericson Smith") writes: > 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 > > * How is it different from the current Perl script out there? > * Can't pg_dump already give us hot backups? Probably what is referred to is this... <http://archives.postgresql.org/pgsql-patches/2006-11/msg00059.php> The "Heap Overflow Tuple" patch. This is intended to improve update behaviour on heavily updated tables. -- select 'cbbrowne' || '@' || 'acm.org'; http://linuxdatabases.info/info/ "A train stops at a train station, a bus stops at a bus station. On my desk I have a work station..."
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.
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@postgresql.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. >
Ericson Smith wrote: > 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 Oh - wasn't aware of that. The HOT that you might see in 8.3 is the one I (and I see Chris) has described - not that project. Regards, Dave