summaryrefslogtreecommitdiff
path: root/src/pl/plpgsql
diff options
context:
space:
mode:
authorPavan Deolasee2015-12-10 05:44:23 +0000
committerPavan Deolasee2015-12-10 05:44:23 +0000
commit39d316ba1927f3238bde0ec24778113894ddfec7 (patch)
tree3f16a11e210116ee00bfdbfee278ac942d7ea7fa /src/pl/plpgsql
parentb8a73559573aa5f87f6c7457d7e49927ce13265c (diff)
Add a developer-GUC 'gloabl_snapshot_source' to allow informed users to
override the way snapshots are computed. The default value of the GUC is 'gtm' which means that snapshots are always generated on the GTM so that we get a full and correct view of the currently running transactions. But with this developer-GUC we now allow users to override that and work with a coordinator generated snapshots. This can be especially useful for read-only queries which now don't need to talk to the GTM. If the snapshots can also be taken locally on a coordinator, this will even further reduce the round-trips to the GTM. Of course, this can lead to consistency issues because a coordinator may not be aware of all the transactions currently running on the XL cluster, especially in a multi-coordinator setup where different coordinators could be running different transactions without knowing about each other's activity. But even in a single coordinator setup, some transactions may start on a datanode and coordinator may not know about them or may only know quite late. Its advised that this feature must be used with caution and after due consideration of the effects
Diffstat (limited to 'src/pl/plpgsql')
0 files changed, 0 insertions, 0 deletions