Timeline for PostgreSql 14 LZ4 not showing pg_column_compression. Not working with COPY import command
Current License: CC BY-SA 4.0
13 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 13 at 4:03 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jul 14 at 12:03 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Mar 12 at 22:03 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Nov 13, 2023 at 13:06 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jul 16, 2023 at 12:03 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Nov 7, 2022 at 8:21 | comment | added | ultimo_frogman | Hi @a_horse_with_no_name thanks for the answer. How can i here contribute it to you? | |
| Nov 7, 2022 at 8:13 | answer | added | ultimo_frogman | timeline score: 0 | |
| Nov 7, 2022 at 6:58 | comment | added | user1822 | A value that is shorter than the compression threshold will not be compressed regardless of the method on how you insert the rows. As the threshold is 2KB, I can't imagine that values in a column named "country" will ever be compressed | |
| Nov 6, 2022 at 14:13 | comment | added | ultimo_frogman | Hi. The columns are being compressed when I do inserts but when I bulk load data with COPY they do not. They get a Null value in pg_column_compression. Maybe the COPY command cannot compress or I need some kind of parameter. | |
| Nov 5, 2022 at 16:16 | comment | added | jjanes | This is a mess. Which queries are you running on which server, and why do the column names keep changing randomly from paragraph to paragraph? Do the same things consistently on each server and summarize the results clearly. | |
| Nov 5, 2022 at 9:25 | comment | added | user1822 | A column named "country" sounds as if the values are too small to be compressed at all. | |
| Nov 5, 2022 at 7:12 | history | edited | ultimo_frogman | CC BY-SA 4.0 |
added 1008 characters in body; edited title
|
| Nov 5, 2022 at 6:59 | history | asked | ultimo_frogman | CC BY-SA 4.0 |