[GENERAL] Cluster table

I'm have this table :  

CREATE TABLE "ITerp"."Dok" (

"id_dok" INTEGER DEFAULT "AutoIncGet"('Dok'::text) NOT NULL,

"sifvrste" CHAR(3) NOT NULL,

"id_objekat1" INTEGER DEFAULT 0,

"id_objekat2" INTEGER DEFAULT 0,

"id_partner" INTEGER DEFAULT 0,

"broj" INTEGER NOT NULL,

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related postgresql.org Links pgsql-admin pgsql-advocacy pgsql-announce pgsql-bugs pgsql-cygwin pgsql-docs pgsql-general pgsql-interfaces pgsql-jdbc pgsql-jobs pgsql-novice pgsql-odbc pgsql-performance pgsql-php pgsql-ports pgsql-sql Request more information about Pantek

"ext" VARCHAR(15),

"datum" DATE DEFAULT date(now()) NOT NULL,

"valuta" DATE DEFAULT date(now()),

"rabat" NUMERIC(10,2),

"opis" VARCHAR(60),

"napomena" VARCHAR(200),

"sumiznos1" NUMERIC(18,2) DEFAULT 0,

"sumporez1" NUMERIC(14,2) DEFAULT 0,

Do you need more help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related postgresql.org Links pgsql-admin pgsql-advocacy pgsql-announce pgsql-bugs pgsql-cygwin pgsql-docs pgsql-general pgsql-interfaces pgsql-jdbc pgsql-jobs pgsql-novice pgsql-odbc pgsql-performance pgsql-php pgsql-ports pgsql-sql Request more information about Pantek

"sumporez2" NUMERIC(14,2) DEFAULT 0,

"sumiznos2" NUMERIC(18,2) DEFAULT 0,

"sumiznos3" NUMERIC(18,2) DEFAULT 0,

"id_komitent" INTEGER NOT NULL,

"radnik" VARCHAR(40),

"vezadok" INTEGER DEFAULT 0,

"vpkkljuc" BOOLEAN DEFAULT false,

"vpkiznos" NUMERIC(18,2) DEFAULT 0.00,

Can we help you?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related postgresql.org Links pgsql-admin pgsql-advocacy pgsql-announce pgsql-bugs pgsql-cygwin pgsql-docs pgsql-general pgsql-interfaces pgsql-jdbc pgsql-jobs pgsql-novice pgsql-odbc pgsql-performance pgsql-php pgsql-ports pgsql-sql Request more information about Pantek

"vpktrosak" NUMERIC(18,2) DEFAULT 0.00,

"status" SMALLINT DEFAULT 0,

"zapisnik" VARCHAR(140) DEFAULT ''::character varying,

"fakbroj" VARCHAR(15),

"vpktip" CHAR(1) DEFAULT ''::bpchar,

"sumiznos4" NUMERIC(18,2) DEFAULT 0.00,

"uplataiznos" NUMERIC(18,2) DEFAULT 0.00,

"uplatadatum" DATE DEFAULT date(now()),

Can't find what you're looking for?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related postgresql.org Links pgsql-admin pgsql-advocacy pgsql-announce pgsql-bugs pgsql-cygwin pgsql-docs pgsql-general pgsql-interfaces pgsql-jdbc pgsql-jobs pgsql-novice pgsql-odbc pgsql-performance pgsql-php pgsql-ports pgsql-sql Request more information about Pantek

"kpismoiznos" NUMERIC(18,2) DEFAULT 0.00,

"kpismodatum" DATE DEFAULT date(now()),

"datumpdv" DATE DEFAULT date(now()),

"altvalutaiznos" NUMERIC(14,4) DEFAULT 0.00,

"altvalutamon" VARCHAR(5) DEFAULT ''::bpchar,

"vpkcarina" BOOLEAN DEFAULT false,

"tipracuna" INTEGER DEFAULT 1,

"cenaext" NUMERIC(14,4) DEFAULT 0.000,

Don't know where to look next?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related postgresql.org Links pgsql-admin pgsql-advocacy pgsql-announce pgsql-bugs pgsql-cygwin pgsql-docs pgsql-general pgsql-interfaces pgsql-jdbc pgsql-jobs pgsql-novice pgsql-odbc pgsql-performance pgsql-php pgsql-ports pgsql-sql Request more information about Pantek

"pecat_i" TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT now(),

"pecat_u" TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT now(),

"idtoken" NUMERIC(14,4),

"id_storno" INTEGER DEFAULT 0,

  CONSTRAINT "Dok_pkey" PRIMARY KEY("id_dok"),

  CONSTRAINT "fk_komitent" FOREIGN KEY ("id_komitent")

    REFERENCES "ITerp"."Komitent"("id_komitent")

    ON DELETE RESTRICT     ON UPDATE RESTRICT     NOT DEFERRABLE,   CONSTRAINT "fk_vrsta" FOREIGN KEY ("sifvrste")

Confused? Frustrated?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related postgresql.org Links pgsql-admin pgsql-advocacy pgsql-announce pgsql-bugs pgsql-cygwin pgsql-docs pgsql-general pgsql-interfaces pgsql-jdbc pgsql-jobs pgsql-novice pgsql-odbc pgsql-performance pgsql-php pgsql-ports pgsql-sql Request more information about Pantek

    REFERENCES "ITerp"."VrstaDok"("sifvrsta")

    ON DELETE RESTRICT     ON UPDATE RESTRICT     NOT DEFERRABLE ) WITHOUT OIDS;     CREATE UNIQUE INDEX "broj_idx_D" ON "ITerp"."Dok"

  USING btree ("sifvrste", "broj", "id_komitent", "id_objekat1");  

CREATE INDEX "cluster_idx_dok" ON "ITerp"."Dok"

  USING btree ("id_komitent", "sifvrste", "datum", "broj", "id_dok");  

CREATE INDEX "datum_idx_Dok" ON "ITerp"."Dok"

  USING btree ("datum");  

CREATE UNIQUE INDEX "fakbroj_idx" ON "ITerp"."Dok"

Call Pantek today for Open Source Technical Support at 1-877-546-8934 - 24/7/365

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related postgresql.org Links pgsql-admin pgsql-advocacy pgsql-announce pgsql-bugs pgsql-cygwin pgsql-docs pgsql-general pgsql-interfaces pgsql-jdbc pgsql-jobs pgsql-novice pgsql-odbc pgsql-performance pgsql-php pgsql-ports pgsql-sql Request more information about Pantek

  USING btree ("id_komitent", "sifvrste", (btrim((fakbroj)::text)))

  WHERE (((((sifvrste = 'OTP'::bpchar) OR (sifvrste = 'FAK'::bpchar)) OR (sifvrste = 'PFK'::bpchar)) OR (sifvrste = 'AVU'::bpchar)) OR (sifvrste = 'AVS'::bpchar));  

CREATE INDEX "idtoken_idx" ON "ITerp"."Dok"

  USING btree ("idtoken");  

CREATE INDEX "komitentD_idx" ON "ITerp"."Dok"

  USING btree ("id_komitent");  

CREATE INDEX "objekat1D_idx" ON "ITerp"."Dok"

  USING btree ("id_objekat1");  

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related postgresql.org Links pgsql-admin pgsql-advocacy pgsql-announce pgsql-bugs pgsql-cygwin pgsql-docs pgsql-general pgsql-interfaces pgsql-jdbc pgsql-jobs pgsql-novice pgsql-odbc pgsql-performance pgsql-php pgsql-ports pgsql-sql Request more information about Pantek

CREATE INDEX "objekat2D_idx" ON "ITerp"."Dok"

  USING btree ("id_objekat2");  

CREATE INDEX "partnerD_idx" ON "ITerp"."Dok"

  USING btree ("id_partner");  

CREATE INDEX "pecat_i_idx_dok" ON "ITerp"."Dok"

  USING btree ("pecat_i");  

CREATE INDEX "sifvrste_idx" ON "ITerp"."Dok"

  USING btree ("sifvrste");  

Do you need more help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related postgresql.org Links pgsql-admin pgsql-advocacy pgsql-announce pgsql-bugs pgsql-cygwin pgsql-docs pgsql-general pgsql-interfaces pgsql-jdbc pgsql-jobs pgsql-novice pgsql-odbc pgsql-performance pgsql-php pgsql-ports pgsql-sql Request more information about Pantek

CREATE INDEX "vezaD_idx" ON "ITerp"."Dok"

  USING btree ("vezadok");    

Table is physically ordered by primary key. I try to cluster table with :  

CLUSTER cluster_idx_dok" ON "ITerp"."Dok" ;  

but Table is still physically ordered by primary key. Why table is not reordered by index? Received on Sun Dec 30 05:52:37 2007