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
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
(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
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
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
?
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
] 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
://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
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
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
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
101 - 111 of 111 matches
Mail list logo