Groups
Sign in
Groups
pg_shard users
Conversations
About
Send feedback
Help
pg_shard users
Contact owners and managers
1–30 of 63
A group for discussing the pg_shard extension. pg_shard shards and replicates PostgreSQL tables, and scales out real-time reads and writes.
To learn more about the extension see
https://github.com/
citusdata/pg_shard
Mark all as read
Report group
0 selected
Ozgun Erdogan
,
Jason Petersen
2
5/25/16
pg_shard doesn't compile with PostgreSQL 9.6dev
Just dropping a note here that this will be addressed in Citus from now on, as `pg_shard` is
unread,locked,
pg_shard doesn't compile with PostgreSQL 9.6dev
Just dropping a note here that this will be addressed in Citus from now on, as `pg_shard` is
5/25/16
rohit...@gmail.com
,
Murat Tuncer
2
5/9/16
Running performnace test on citusdb vs postgres_xl
This question is answered in citus-users forum at https://groups.google.com/forum/#!topic/citus-users
unread,locked,
Running performnace test on citusdb vs postgres_xl
This question is answered in citus-users forum at https://groups.google.com/forum/#!topic/citus-users
5/9/16
Eugen Konkov
,
Sumedh Pathak
2
4/28/16
How to configure shard to store foreign data
Hi Eugen, A quick note that pg_shard has reached end-of-life, and the product has been merged into
unread,locked,
How to configure shard to store foreign data
Hi Eugen, A quick note that pg_shard has reached end-of-life, and the product has been merged into
4/28/16
Kesav Kumar Kolla
,
Murat Tuncer
2
4/6/16
Shard based on schema
Hello Kesav pg_shard is intended to distributed a single table based on its column. If having a
unread,locked,
Shard based on schema
Hello Kesav pg_shard is intended to distributed a single table based on its column. If having a
4/6/16
n0ctu...@gmail.com
, …
Murat Tuncer
6
4/5/16
Is replication supported?
Hello Khan You could follow the instructions at pg_shard github page at https://github.com/citusdata/
unread,locked,
Is replication supported?
Hello Khan You could follow the instructions at pg_shard github page at https://github.com/citusdata/
4/5/16
pg_shard users
3/25/16
Announcement
The Future of pg_shard
Near the end of 2014, Citus Data released pg_shard, the first open-source sharding extension for
unread,locked,
Announcement
The Future of pg_shard
Near the end of 2014, Citus Data released pg_shard, the first open-source sharding extension for
3/25/16
Yan Cheng Cheok
,
Sumedh Pathak
2
3/21/16
Some questions regarding how data is distributed among servers during real-time insertion
Hi Yan Cheng, See my responses in-line: On Friday, March 18, 2016 at 3:15:06 AM UTC-7, Yan Cheng
unread,
Some questions regarding how data is distributed among servers during real-time insertion
Hi Yan Cheng, See my responses in-line: On Friday, March 18, 2016 at 3:15:06 AM UTC-7, Yan Cheng
3/21/16
Priyesh Karatha
,
Sumedh Pathak
2
3/21/16
how tp do dynamic scaling using pg_shard and VMs
Hi Priyesh, Thanks for your question, and sorry for the delay in getting back to you. As I understand
unread,
how tp do dynamic scaling using pg_shard and VMs
Hi Priyesh, Thanks for your question, and sorry for the delay in getting back to you. As I understand
3/21/16
Yan Cheng Cheok
, …
ad...@mux.co
6
3/18/16
Is table partitioning being supported in CitusDB ?
Hi Onder, tablename_shardid is close but not exactly what I want. What I want is tablename_yymmdd (
unread,
Is table partitioning being supported in CitusDB ?
Hi Onder, tablename_shardid is close but not exactly what I want. What I want is tablename_yymmdd (
3/18/16
chetan....@bizruntime.com
,
Onder Kalaci
2
3/17/16
How to define range for shard.
Hi, pg_shard uses hash partitioning, which means that the rows are distributed with respect to
unread,
How to define range for shard.
Hi, pg_shard uses hash partitioning, which means that the rows are distributed with respect to
3/17/16
Yan Cheng Cheok
, …
James Wang
3
2/29/16
comparison of JOIN query speed
What is your query explain (I am from MySQL) results please? On Wednesday, 24 February 2016 05:34:36
unread,
comparison of JOIN query speed
What is your query explain (I am from MySQL) results please? On Wednesday, 24 February 2016 05:34:36
2/29/16
Yan Cheng Cheok
,
Onder Kalaci
3
2/24/16
Is insertion speed for master with shards will always slower than master without shard's?
Hi Onder, Thank you for your info. In short, we tend to store "view", "lead" and
unread,
Is insertion speed for master with shards will always slower than master without shard's?
Hi Onder, Thank you for your info. In short, we tend to store "view", "lead" and
2/24/16
Yan Cheng Cheok
,
Onder Kalaci
2
2/23/16
Is it possible to perform copy_to_distributed_table or stage directly from memory data?
Hi Yen, Unfortunealty current implementation of copy_to_distributed_table expects to read the data
unread,
Is it possible to perform copy_to_distributed_table or stage directly from memory data?
Hi Yen, Unfortunealty current implementation of copy_to_distributed_table expects to read the data
2/23/16
shankar
,
Onder Kalaci
11
1/29/16
rebalance_table_shards is not working
Hi Onder, I setup cluster with all EC2 instances. 1 Master and 3 worker nodes and all are installed
unread,
rebalance_table_shards is not working
Hi Onder, I setup cluster with all EC2 instances. 1 Master and 3 worker nodes and all are installed
1/29/16
shankar
,
Marco Slot
3
12/22/15
MATERIALIZED VIEW on pg_shard
Hi Macro, Thank you for the explanation. Regards Shankar On Monday, December 21, 2015 at 2:55:44 PM
unread,
MATERIALIZED VIEW on pg_shard
Hi Macro, Thank you for the explanation. Regards Shankar On Monday, December 21, 2015 at 2:55:44 PM
12/22/15
shankar
,
Onder Kalaci
12
12/22/15
pgs_distribution_metadata schema contains tables or views?
Hi Onder, Thank you very much. Regards Shankar On Wednesday, November 11, 2015 at 5:15:56 PM UTC+5:30
unread,
pgs_distribution_metadata schema contains tables or views?
Hi Onder, Thank you very much. Regards Shankar On Wednesday, November 11, 2015 at 5:15:56 PM UTC+5:30
12/22/15
shankar
,
Onder Kalaci
6
12/15/15
Creating index on pg_shard distributed table
Thats great Onder. Thanks Sankar On Friday, December 4, 2015 at 12:07:20 AM UTC+5:30, shankar wrote:
unread,
Creating index on pg_shard distributed table
Thats great Onder. Thanks Sankar On Friday, December 4, 2015 at 12:07:20 AM UTC+5:30, shankar wrote:
12/15/15
FattahRozzaq
, …
Dorian Hoxha
6
11/29/15
Is CitusDB free?
Looks like Citusdb IS going opensource on their 5.0 release which should be on Q1 2016: source: https
unread,
Is CitusDB free?
Looks like Citusdb IS going opensource on their 5.0 release which should be on Q1 2016: source: https
11/29/15
FattahRozzaq
, …
Onder Kalaci
12
11/3/15
How to restore an PostgreSQL vanilla dump to the database PostgreSQL+pg_shard?
Hi Onder, Big thanks for your support. You really helped us a lot through this mailing list. Thank
unread,
How to restore an PostgreSQL vanilla dump to the database PostgreSQL+pg_shard?
Hi Onder, Big thanks for your support. You really helped us a lot through this mailing list. Thank
11/3/15
Rishabh Chaudhary
,
Onder Kalaci
6
10/21/15
cant read data from master
Hi Risbash, I haven't tried pg_shard with pg_partman. But, I try to understand your use case
unread,
cant read data from master
Hi Risbash, I haven't tried pg_shard with pg_partman. But, I try to understand your use case
10/21/15
Rishabh Chaudhary
,
Onder Kalaci
7
10/13/15
data updation during failure of Worker Node
Hi, Thanks a lot! I missed out on the last step. That was a great help. :) On Tuesday, October 13,
unread,
data updation during failure of Worker Node
Hi, Thanks a lot! I missed out on the last step. That was a great help. :) On Tuesday, October 13,
10/13/15
Quân Nguyễn Hồng
,
Onder Kalaci
2
10/13/15
Using SQLBindParameter and SQLExecDirect fail on CitusDB
Hi, CitusDB currently supports PREPARE statements for SELECTs. During INSERTs, we delegate the
unread,
Using SQLBindParameter and SQLExecDirect fail on CitusDB
Hi, CitusDB currently supports PREPARE statements for SELECTs. During INSERTs, we delegate the
10/13/15
armand pirvu
,
Onder Kalaci
3
9/8/15
pg_shard and pgbouncer
Roger that Onder For some reason I thought I did not understand the basics and whilst the question
unread,
pg_shard and pgbouncer
Roger that Onder For some reason I thought I did not understand the basics and whilst the question
9/8/15
Sanjana Sridhar
,
Jason Petersen
5
9/2/15
Unable to query the main table but able to query the individual shards
Hello Jason, Just wondering if you have any insight on this. I am now having the same problems with
unread,
Unable to query the main table but able to query the individual shards
Hello Jason, Just wondering if you have any insight on this. I am now having the same problems with
9/2/15
Jeff Mundine
, …
Ozgun Erdogan
4
8/27/15
Some Basic pointers
Hi Jeff, We're working on improving our documentation and providing more examples. Your
unread,
Some Basic pointers
Hi Jeff, We're working on improving our documentation and providing more examples. Your
8/27/15
Ozgun Erdogan
,
Jason Petersen
2
8/24/15
Column value to shard mappings in pg_shard
On Aug 12, 2015, at 12:50 PM, Ozgun Erdogan <oz...@citusdata.com> wrote: It looks like the
unread,
Column value to shard mappings in pg_shard
On Aug 12, 2015, at 12:50 PM, Ozgun Erdogan <oz...@citusdata.com> wrote: It looks like the
8/24/15
Anurag Arora
, …
anurag...@gmail.com
3
8/19/15
Can pg_shard be used only for replication between two master servers ?
Hi Jason, thanks for your reply. Yes, I have looked into BDR, but because of patched version I am not
unread,
Can pg_shard be used only for replication between two master servers ?
Hi Jason, thanks for your reply. Yes, I have looked into BDR, but because of patched version I am not
8/19/15
armand pirvu
,
Jason Petersen
6
8/17/15
Performance question
Well duh me I noticed the page has a comment box Will use that, although truth to be told i would
unread,
Performance question
Well duh me I noticed the page has a comment box Will use that, although truth to be told i would
8/17/15
armand pirvu
,
Jason Petersen
5
8/17/15
Delete/Update - functionality
Thank you Jason Armand On Monday, August 17, 2015 at 2:51:20 PM UTC-5, Jason Petersen wrote: On Aug
unread,
Delete/Update - functionality
Thank you Jason Armand On Monday, August 17, 2015 at 2:51:20 PM UTC-5, Jason Petersen wrote: On Aug
8/17/15
armand pirvu
,
Jason Petersen
5
8/17/15
bigserial insert error
Thank you Jason Armand On Monday, August 17, 2015 at 2:23:33 PM UTC-5, Jason Petersen wrote: On Aug
unread,
bigserial insert error
Thank you Jason Armand On Monday, August 17, 2015 at 2:23:33 PM UTC-5, Jason Petersen wrote: On Aug
8/17/15