Re: [HACKERS] Some questions about mammoth replication

2007-10-12 Thread Alexey Klyukin
are replicated. Do you replay it as SQL insert/update/delete commands, or directly on heap/indexes ? We replay the commands directly using heap/index functions on a slave. Regards, -- Alexey Klyukin http://www.commandprompt.com/ The PostgreSQL Company - Command Prompt

Re: [HACKERS] Some questions about mammoth replication

2007-10-12 Thread Alexey Klyukin
replicated table. We replicate only data however, not DDL commands to create/alter table or sequence. Or you just use lower-level versions on INSERT/UPDATE/DELETE ? - Hannu Regards, -- Alexey Klyukin http://www.commandprompt.com/ The PostgreSQL

Re: [HACKERS] Some questions about mammoth replication

2007-10-11 Thread Alexey Klyukin
(I don't know if Skytools can). Replicator doesn't have this limitation. Regards, -- Alexey Klyukin http://www.commandprompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---(end of broadcast)--- TIP 6: explain analyze

Re: [HACKERS] Some questions about mammoth replication

2007-10-11 Thread Alexey Klyukin
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 approach can only replicate data for the commands which fire

Re: [HACKERS] GIT patch

2007-08-02 Thread Alexey Klyukin
index tuple, in normal index scans, if we go with alternative 1. Or support to do binary searches over them, if we go with alternative 2 or 3. As the patch stands, the sorting is done within b-tree, but that's quite ugly. -- Alexey Klyukin http://www.commandprompt.com

[HACKERS] GIT patch review

2007-05-23 Thread Alexey Klyukin
? 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 desire to choose an index

Re: [HACKERS] Subversion repo up

2007-05-03 Thread Alexey Klyukin
] http://subversion.tigris.org/svn_1.4_releasenotes.html#svnsync [2] http://projects.commandprompt.com/public/pgsql/repo/ Regards, -- Alexey Klyukin http://www.commandprompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---(end of broadcast

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

2007-04-12 Thread Alexey Klyukin
://projects.commandprompt.com/public/pgsql/repo/ Regards, -- Alexey Klyukin [EMAIL PROTECTED] ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org

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

2007-04-12 Thread Alexey Klyukin
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 http

Re: [HACKERS] plperl/plperlu interaction

2006-10-29 Thread Alexey Klyukin
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

Re: [HACKERS] Replication documentation addition

2006-10-26 Thread Alexey Klyukin
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, Alexey Klyukin

<    1   2