citusdata / citusdata/cstore_fdw

Creating other FDW table generates files in $PGDATA/cstore_fdw/(database's oid)

Open
#104 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
1.8k
Forks
169
PR merge metrics
No merged PRs in 30d

Description

When I created a mysql_fdw table after setting up cstore_fdw, I found data file and footer file were generated in $PGDATA/cstore_fdw/(database's oid).

```
datatank=> CREATE SERVER mysql_server
datatank-> FOREIGN DATA WRAPPER mysql_fdw
datatank-> OPTIONS (host '127.0.0.1', port '3306');
CREATE SERVER
datatank=> CREATE USER MAPPING FOR postgres
datatank-> SERVER mysql_server
datatank-> OPTIONS (username 'foo', password 'bar');
CREATE USER MAPPING
datatank=> CREATE FOREIGN TABLE warehouse(
datatank(> warehouse_id int,
datatank(> warehouse_name text)
datatank-> SERVER mysql_server
datatank-> OPTIONS (dbname 'db', table_name 'warehouse');
CREATE FOREIGN TABLE
datatank=> select relfilenode from pg_class where relname = 'warehouse' and relkind = 'f';
relfilenode
-------------
16454
(1 row)

/mnt/postgresql/9.5/main/cstore_fdw/16386# ls -ltr
total 404
-rw------- 1 postgres postgres 54 Jun 20 02:40 16422.footer
-rw------- 1 postgres postgres 397099 Jun 20 02:40 16422
-rw------- 1 postgres postgres 26 Jun 21 09:00 16454.footer
-rw------- 1 postgres postgres 0 Jun 21 09:00 16454
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.