postgresql - vertical database partitioning in postgres 9.2 -


i have table 60 columns , want vertically partition it, more or dividing in further small tables divided in columns. how vertical partitioning in database using postgres 9.2? did alot of google couldnt find helpful.

table want vertically partition is:

create table insurance.vt_owner (   regn_no character varying(10) not null,   regn_dt timestamp without time zone,   purchase_dt timestamp without time zone,   owner_sr numeric(5,0),   owner_name character varying(150),   pan_no character varying(10),   f_name character varying(150),   c_add1 character varying(50),   c_add2 character varying(50),   c_city character varying(50),   c_district character varying(30),   c_pincode character varying(6),   p_add1 character varying(50),   p_add2 character varying(50),   p_city character varying(50),   p_district character varying(30),   p_pincode character varying(6),   owner_cd numeric(5,0),   owner_cd_desc character varying(50),   regn_type character varying(1),   regn_type_desc character varying(50),   vh_class numeric(5,0),   vh_class_desc character varying(50),   chasi_no character varying(30),   eng_no character varying(30),   maker numeric(5,0),   maker_desc character varying(50),   maker_model character varying(50),   body_type character varying(3),   body_type_desc character varying(50),   no_cyl numeric(2,0),   hp character varying(10),   seat_cap numeric(3,0),   stand_cap numeric(3,0),   sleeper_cap numeric(2,0),   unld_wt numeric(9,0),   ld_wt numeric(9,0),   fuel numeric(3,0),   fuel_desc character varying(50),   color character varying(50),   manu_mon numeric(2,0),   manu_yr numeric(4,0),   fit_dt timestamp without time zone,   norms numeric(2,0),   norms_desc character varying(50),   wheelbase character varying(10),   cubic_cap character varying(10),   floor_area numeric(7,3),   ac_fiitted character(1),   audio_fiitted character(1),   video_fiitted character(1),   vch_purchase_as character(1),   vch_catg character(3),   dealer_cd numeric(5,0),   dealer_cd_desc character varying(50),   sale_amt numeric(9,0),   laser_code character varying(10),   garage_add character varying(50),   state_cd character varying(2) not null,   rto_cd character varying(3) not null,   constraint vt_owner_pkey primary key (state_cd, rto_cd, regn_no) ) (   oids=false ); alter table insurance.vt_owner   owner postgres;  -- index: insurance."index_vt_owner"  -- drop index insurance."index_vt_owner";  create index "index_vt_owner"   on insurance.vt_owner   using btree   (regn_no collate pg_catalog."default", chasi_no collate pg_catalog."default", state_cd collate pg_catalog."default", rto_cd collate pg_catalog."default");

thanks in advance

i don't think going decent answer unless specify why want vertically partition. sharding? performance? denormalizing? columns necessary in bulk of queries?

somewhat related, if dataset (uncompressed) in under 1tb, can try vertica's community edition free, subject licensing restrictions (read fine print). vertica columnar storage database , many use-cases remarkably fast. i've used in past analytics , worked (there gotchas of course).


Comments

Post a Comment

Popular posts from this blog

How to mention the localhost in android -

i trying call localhost in android application. unfortunately not possible used several methods emulator local host http://10.0.2.2/android/dbconnection.php and network ip address http://192.168.1.xx/android/dbconnection.php also http://localhost:8080/android/dbconnection.php but nothing connected localhost. purpose refer stackoverflow answers not working i facing same problem when worked on localhost. referred stackoverflow answer got solution create new emulator works fine in new emulator.
Read more

php - Calling a template part from a post -

i include iframe within post in wordpress. located inside content of post, meaning cannot in post template file, otherwise either before or after. i'd add facebook plugin within posts: <div id="socialwrap"><div class="fb-like" data-href="http://onlinearizonahomes.info" data-send="true" data-width="450" data-show-faces="true" data-font="arial"></div></div> i thinking of calling template part within post <?php get_template_part( 'social' ); ?> cannot use php within post without plugin (i'd avoid using plugin this). an alternative using javascript create html in post, seems unnecessary use of javascript. what best way add html within wordpress post? you can use shortcode. add functions.php function cudjex_fbshare( $atts, $content = null ) { global $post; $link = get_permalink($post->id); return '<div id="socialwrap...
Read more

c# - String.format() DateTime With Arabic culture -

check below code snippet, namespace testdateconvertion { class program { static void main(string[] args) { datetime testvalue = new datetime(2013, 12, 15, 15, 33, 44); cultureinfo culture = new cultureinfo("ar-sa"); string stringvalue = string.format(culture, "{0:d} {0:hh:mm:ss}", testvalue); console.writeline(stringvalue); console.readline(); } } } it gives output 22/02/35 15:33:44 i not getting how possible. whats 35 doing in output there that's 13/12/2015 in hijri, 35 means 1435 in hijri, default date format saudi arabia.
Read more