Git Product home page Git Product logo

Comments (5)

schmiddy avatar schmiddy commented on September 28, 2024

Could we see a table schema, and what command-line args you were calling pg_repack with?

from pg_repack.

pfote avatar pfote commented on September 28, 2024

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.

j16sdiz avatar j16sdiz commented on September 28, 2024

update_partition << so this is a partition table? how those partitions are organized?

from pg_repack.

MichaelDBA avatar MichaelDBA commented on September 28, 2024

wondering why this issue is not closed by authors, since the person never responded back to @j16sdiz SEVEN FREAKIN YEARS AGO

from pg_repack.

MichaelDBA avatar MichaelDBA commented on September 28, 2024

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)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo 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.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.