Skip to content

Commit 754e320

Browse files
authored
Update README.md
Fix several typos
1 parent 9b72640 commit 754e320

File tree

1 file changed

+14
-14
lines changed

1 file changed

+14
-14
lines changed

README.md

Lines changed: 14 additions & 14 deletions
Original file line numberDiff line numberDiff line change
@@ -33,17 +33,17 @@ More interesting features are yet to come. Stay tuned!
3333

3434
## Roadmap
3535
* Replace INSERT triggers with a custom node (aka **PartitionFilter**)
36-
* Implement concurrent partitioning (much more responsive)
37-
* Implement HASH-patitioning for non-integer attributes
36+
* Implement [concurrent partitioning](https://github.com/postgrespro/pg_pathman/tree/concurrent_part) (much more responsive)
37+
* Implement HASH partitioning for non-integer attributes
3838
* Optimize hash join (both tables are partitioned by join key)
39-
* Implement LIST patitioning scheme
39+
* Implement LIST partitioning scheme
4040

4141
## Installation guide
4242
To install `pg_pathman`, execute this in the module's directory:
4343
```
4444
make install USE_PGXS=1
4545
```
46-
Modify the **`shared_preload_libraries`** parameter in `postgres.conf` as following:
46+
Modify the **`shared_preload_libraries`** parameter in `postgresql.conf` as following:
4747
```
4848
shared_preload_libraries = 'pg_pathman'
4949
```
@@ -66,7 +66,7 @@ create_hash_partitions(relation TEXT,
6666
```
6767
Performs HASH partitioning for `relation` by integer key `attribute`. Creates `partitions_count` partitions and trigger on INSERT. All the data will be automatically copied from the parent to partitions.
6868

69-
```
69+
```plpgsql
7070
create_range_partitions(relation TEXT,
7171
attribute TEXT,
7272
start_value ANYELEMENT,
@@ -107,52 +107,52 @@ create_range_update_trigger(parent TEXT)
107107
Same as above, but for a RANGE-partitioned table.
108108

109109
### Post-creation partition management
110-
```
110+
```plpgsql
111111
split_range_partition(partition TEXT, value ANYELEMENT)
112112
```
113113
Split RANGE `partition` in two by `value`.
114114

115-
```
115+
```plpgsql
116116
merge_range_partitions(partition1 TEXT, partition2 TEXT)
117117
```
118118
Merge two adjacent RANGE partitions. First, data from `partition2` is copied to `partition1`, then `partition2` is removed.
119119

120-
```
120+
```plpgsql
121121
append_range_partition(p_relation TEXT)
122122
```
123123
Append new RANGE partition.
124124

125-
```
125+
```plpgsql
126126
prepend_range_partition(p_relation TEXT)
127127
```
128128
Prepend new RANGE partition.
129129

130-
```
130+
```plpgsql
131131
add_range_partition(relation TEXT,
132132
start_value ANYELEMENT,
133133
end_value ANYELEMENT)
134134
```
135135
Create new RANGE partition for `relation` with specified range bounds.
136136

137-
```
137+
```plpgsql
138138
drop_range_partition(partition TEXT)
139139
```
140140
Drop RANGE partition and all its data.
141141

142-
```
142+
```plpgsql
143143
attach_range_partition(relation TEXT,
144144
partition TEXT,
145145
start_value ANYELEMENT,
146146
end_value ANYELEMENT)
147147
```
148148
Attach partition to the existing RANGE-partitioned relation. The attached table must have exactly the same structure as the parent table, including the dropped columns.
149149

150-
```
150+
```plpgsql
151151
detach_range_partition(partition TEXT)
152152
```
153153
Detach partition from the existing RANGE-partitioned relation.
154154

155-
```
155+
```plpgsql
156156
disable_partitioning(relation TEXT)
157157
```
158158
Permanently disable `pg_pathman` partitioning mechanism for the specified parent table and remove the insert trigger if it exists. All partitions and data remain unchanged.

0 commit comments

Comments
 (0)