Where are the shard tables? First-time user confusion

Rich MacDonald

unread,

Jan 28, 2023, 3:54:39 PM1/28/23

to citus-users

I've read the available documentation and set up a citus network with one coordinator and two workers. Each database runs in its own docker container. Communication seems to be working.

I created a test table <mytable> in the coordinator database, added some records, then called 'create_distributed_table'. This created matching tables in the 2 workers with the same name.

All 3 tables appear to contain all the records. Plus, there are no shard tables. I thought I was going to get a series of <mytable_shardid> tables.

I am calling <pg_catalog.pg_tables> to get the list of tables.

Have I completely hosed my installation, or is this expected behavior?

Rich MacDonald

Rich MacDonald

unread,

Jan 29, 2023, 3:57:32 PM1/29/23

to citus-users

Guess I needed to read the documentation on configuration options, so I could learn about show_shards_for_app_name_prefixes

Onur Tırtır

unread,

Jan 30, 2023, 8:35:14 AM1/30/23

to citus-users

Exactly, if you append "psql" to that config, then you would be able to see those shards on worker nodes.

29 Ocak 2023 Pazar tarihinde saat 23:57:32 UTC+3 itibarıyla macdona...@gmail.com şunları yazdı:

Reply all

Reply to author

Forward