Comments (5)
Could we see a table schema, and what command-line args you were calling pg_repack
with?
from pg_repack.
schema, parent table has the same
Column | Type | Modifiers
---------------+-----------------------------+--------------------------------------------------------------------------
dep_apt | character(3) | not null
dst_apt | character(3) | not null
dep_date | date | not null
ret_date | date | not null
cr | character varying(3) | not null
price | numeric |
currency | character(3) | not null
farebase_out | character varying(30) |
farebase_in | character varying(30) |
flight_out | character varying(1000) |
flight_in | character varying(1000) |
last_change | timestamp without time zone | not null default now()
faretype | character(3) | not null default 'PUB'::bpchar
tax | numeric | default 0.0
ccfee | numeric |
agent | character varying(255) |
conso | character varying(255) |
corpcode | character varying(20) |
mp_cache_md5 | character(32) | not null default ''::bpchar
sort_price | numeric |
cheapest_fare | boolean | not null default false
real_dst_apt | character(3) |
real_dep_apt | character(3) |
dep_country | character(2) |
dep_area | character(4) |
dst_country | character(2) |
dst_area | character(4) |
ccfee_other | numeric |
id | bigint | not null default nextval('cache_cheapest_flight_other_id_seq'::regclass)
Indexes:
"cache_cheapest_flight_other_pkey1" PRIMARY KEY, btree (id)
"cache_cheapest_flight_other_pkey" UNIQUE, btree (dep_apt, dst_apt, dep_date, ret_date, cr, currency, faretype, agent, conso)
"cache_cheapest_flight_other_dep_apt_dst_apt_dep_country_dst_idx" btree (dep_apt, dst_apt, dep_country, dst_country)
"cache_cheapest_flight_other_dep_apt_dst_apt_price_idx" btree (dep_apt, dst_apt, price)
"cache_cheapest_flight_other_dep_apt_price_idx" btree (dep_apt, price)
"cache_cheapest_flight_other_dep_apt_sort_price_idx" btree (dep_apt, sort_price)
"cache_cheapest_flight_other_dep_date_idx" btree (dep_date)
"cache_cheapest_flight_other_dst_apt_last_change_idx" btree (dst_apt, last_change)
"idx_cache_cheapest_flight_country_area2_other" btree (dep_country, dst_area, dep_date, ret_date, faretype, agent, conso, tax, cr)
"idx_cache_cheapest_flight_country_area_other" btree (cr, dep_country, dst_area, dep_date, ret_date, faretype, agent, conso, tax)
"idx_cache_cheapest_flight_country_country_other" btree (cr, dep_country, dst_country, dep_date, ret_date, faretype, agent, conso, tax)
"idx_cache_cheapest_flight_other_dep_date_minus_ret_date" btree ((ret_date - dep_date))
"idx_cache_cheapest_flight_other_dst_apt" btree (dst_apt)
"idx_cache_cheapest_flight_other_last_change" btree (last_change)
"idx_cache_cheapest_flight_other_month_of_dep_date" btree (date_part('month'::text, dep_date))
"idx_cache_cheapest_flight_other_month_of_dep_date_extended" btree (date_part('month'::text, dep_date), (ret_date - dep_date), dep_date, currency)
"idx_cache_cheapest_flight_other_tax_update" btree (cr, dep_apt, dst_apt, faretype, currency, dep_date, ret_date)
"idx_cache_cheapest_flight_other_text_index" btree (dep_apt, dep_date, last_change)
"idx_cache_cheapest_flight_routes_other" btree (cr, dep_date, last_change, dep_country, dst_country, dep_apt, dst_apt)
Check constraints:
"cache_cheapest_flight_other_dep_apt_check" CHECK (dep_apt <> ALL (ARRAY['AMS'::bpchar, 'BER'::bpchar, 'BRE'::bpchar, 'CGN'::bpchar, 'DUB'::bpchar, 'DUS'::bpchar, 'EAP'::bpchar, 'FRA'::bpchar, 'HAJ'::bpchar, 'HAM'::bpchar, 'LON'::bpchar, 'MIL'::bpchar, 'MUC'::bpchar, 'NUE'::bpchar, 'NYC'::bpchar, 'PAR'::bpchar, 'STR'::bpchar, 'VIE'::bpchar, 'ZRH'::bpchar]))
Triggers:
update_partition BEFORE INSERT OR UPDATE ON cache_cheapest_flight_other FOR EACH ROW EXECUTE PROCEDURE update_cheapest()
Inherits: cache_cheapest_flight
repack was called with no special options
/usr/lib/postgresql/9.3/bin/pg_repack -t cache_cheapest_flight_other yps_cache
from pg_repack.
update_partition << so this is a partition table? how those partitions are organized?
from pg_repack.
wondering why this issue is not closed by authors, since the person never responded back to @j16sdiz SEVEN FREAKIN YEARS AGO
from pg_repack.
Closing this issue since no response from @pfote for quite a few years! Also, partitioning has come a long way since 2015 when PG 9.5 was the current version and declarative partitioning was still years away from being a reality.
from pg_repack.
Related Issues (20)
- pg_repack error:column "relhasoids" does not exist HOT 7
- simple_prompt() hangs because SIGINT handler was overridden
- Question: Does pg_repack repack indexes when repacking table HOT 2
- Exists orphan files in secondary server after the repack. HOT 5
- The table is moved to tablespace pg _default from database default tablespace HOT 2
- pg_repack use SeqScan for read table. Can we use Parallel Seq Scan like the Command Copy does? HOT 2
- Overriding `idle_in_transaction_session_timeout` doesn't seem to work properly HOT 5
- Invalid OIDs can crash the database HOT 2
- Refactor `lib/pg_repack.sql.in`
- pg_repack without primary/unique index HOT 1
- All target table reads & writes blocked because of autovacuum on repack temporary table HOT 3
- Missing changes in `swap_head_or_index_files()`
- Respect table order list passed as argument HOT 1
- pg_repack 1.5.0 signed integer in name of log table lead to errors HOT 4
- Notices in pg_repack1.4.5 logs for AWS Aurora PostgreSQL 12.8 indicate waiting for transactions to finish with specific PIDs unrelated to the table being repacked. HOT 13
- Passwords in .pgpass with spaces cause error Unable to set up worker conn #0: missing "=" HOT 2
- LOCK TABLE can only be used in transaction blocks HOT 2
- Usage without client? HOT 2
- version 1.5.0 pg_repack the pg_repack command returns an ERROR: the request was not executed: ERROR: the tablespace ""XXXX"" does not exist HOT 5
- pg_repack v.1.4.7 won't build HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pg_repack.