Re: [HACKERS] Some questions about mammoth replication

slaves should match the table structure on master. > That is, do you replicate a physical table image > (maybe not including transaction ids on master) ? Yes, we call this 'full dump', and it is fired automatically for every replicated table. We replicate only data however, not DDL comman

Re: [HACKERS] Some questions about mammoth replication

or > > > do you apply the changes at some lower level ? > > > > We replicate the binary data along with a command type. Only the data > > necessary to replay the command on a slave are replicated. > > Do you replay it as SQL insert/update/delete comm

Re: [HACKERS] Some questions about mammoth replication

Marko Kreen wrote: > On 10/11/07, Alexey Klyukin <[EMAIL PROTECTED]> wrote: > > Hannu Krosing wrote: > > > For what use cases do you think your WAL-based approach is better than > > > Slony/Skytools trigger-based one ? > > > > A pure trigger based appr

Re: [HACKERS] Some questions about mammoth replication

eplicate data for the commands which fire triggers. AFAIK Slony is unable to replicate TRUNCATE command (I don't know if Skytools can). Replicator doesn't have this limitation. Regards, -- Alexey Klyukin http://www.commandprompt.com/ The Po

Re: [HACKERS] GIT patch

ed a version which applies (or applied to the cvs head at the time of post) cleanly there: http://archives.postgresql.org/pgsql-patches/2007-06/msg00204.php > > 2. Support to sort the heap tuples represented by one index tuple, in > normal index scans, if we go with alternative

[HACKERS] GIT patch review

ons on reviewing the GIT patch ? Regards, -- Alexey Klyukin http://www.commandprompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your de

Re: [HACKERS] Subversion repo up

from > the main cvs repository? > > kind regards, > Hannes Eder > > Footnotes: > [1] http://subversion.tigris.org/svn_1.4_releasenotes.html#svnsync > [2] http://projects.commandprompt.com/public/pgsql/repo/ > Regards, -- Alexey Klyukin

Re: [HACKERS] What tools do people use to hack on PostgreSQL?

mit I haven't tried. I have tried and svn up worked without issues. Regards, -- Alexey Klyukin [EMAIL PROTECTED] ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at

Re: [HACKERS] What tools do people use to hack on PostgreSQL?

http://projects.commandprompt.com/public/pgsql/browser or do the anonymous checkout with: svn co http://projects.commandprompt.com/public/pgsql/repo/ Regards, -- Alexey Klyukin [EMAIL PROTECTED] ---(end of broadcast)

Re: [HACKERS] plperl/plperlu interaction

Jeremy Drake wrote: On Thu, 26 Oct 2006, Alvaro Herrera wrote: Jeff Trout wrote: On Oct 26, 2006, at 3:23 PM, Martijn van Oosterhout wrote: On Thu, Oct 26, 2006 at 03:15:00PM -0400, Andrew Dunstan wrote: Perhaps people who use other platforms could look for these fla

Re: [HACKERS] Replication documentation addition

Hi, A typo: ("a write to any server has to be _propogated_") s/propogated/propagated Bruce Momjian wrote: Here is a new replication documentation section I want to add for 8.2: ftp://momjian.us/pub/postgresql/mypatches/replication Comments welcomed. -- Regards, Alex

<    1   2