Skip site navigation (1) Skip section navigation (2)

Re: Vacuumdb

From: Mario Soto Cordones - Venezuela <msotocl(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: pgsql-es postgresql <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: Re: Vacuumdb
Date: 2005-07-26 15:03:57
Message-ID: e9b17cde05072608034aea2fc0@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-es-ayuda
Hola esta es la estructura de la tabla.

CREATE TABLE "valoracion"."svavaluo" (
  "id_estado" CHAR(2) DEFAULT 'SA'::bpchar NOT NULL, 
  "co_empresa" INTEGER DEFAULT 0 NOT NULL, 
  "co_filial" NUMERIC(6,0) NOT NULL, 
  "nu_activo_fijo" VARCHAR(60) NOT NULL, 
  "nu_año_valoracion" NUMERIC(4,0) NOT NULL, 
  "fe_valorizacion" DATE NOT NULL, 
  "nu_documento" NUMERIC(12,0) DEFAULT 0 NOT NULL, 
  "ip_equipo" VARCHAR(18) DEFAULT ' '::character varying NOT NULL, 
  "co_metodo" INTEGER DEFAULT 0 NOT NULL, 
  "co_item" INTEGER DEFAULT 0 NOT NULL, 
  "va_item" NUMERIC(20,4) DEFAULT 0, 
  "id_usuario" VARCHAR(30) DEFAULT 'MSOTO'::character varying NOT NULL, 
  "sq_serialcolumn" SERIAL, 
  "co_modelo" INTEGER NOT NULL, 
  "co_tipo_modelo" INTEGER, 
  "nb_item" VARCHAR(255) DEFAULT 0, 
  CONSTRAINT "svavaluo_pk_svavaluos" PRIMARY KEY("co_empresa",
"co_filial", "nu_activo_fijo", "nu_año_valoracion", "co_metodo",
"co_item", "sq_serialcolumn"),
  CONSTRAINT "svavaluo_sq_serialcolumn_key" UNIQUE("sq_serialcolumn")
) WITH OIDS;

Segun la documentacion  :

EXAMPLES
       Cluster the table employees on the basis of its index emp_ind:

       CLUSTER emp_ind ON emp;

       Cluster the employees table using the same index that was used before:

       CLUSTER emp;

       Cluster all tables in the database that have previously been clustered:

       CLUSTER;


Mi duda es si al hacer el cluster a la tabla sin especificar el
indice, este no deberiia tomar el primary key ???? o es incorrecto
....

Saludos


El 26/07/05, Alvaro Herrera<alvherre(at)alvh(dot)no-ip(dot)org> escribió:
> On Tue, Jul 26, 2005 at 10:19:15AM -0400, Mario Soto Cordones - Venezuela wrote:
> > Hola al hacer:
> >
> > cluster valoracion.svavaluo
> 
> Tienes que especificar un indice a CLUSTER.
> 
> > Segun la documentacion
> >
> > puedo omitir un indice y solo especificar la tabla, pero al parecer no
> > me funciona esto,
> 
> Por favor lee bien la documentacion.
> 
> --
> Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
> You liked Linux a lot when he was just the gawky kid from down the block
> mowing your lawn or shoveling the snow. But now that he wants to date
> your daughter, you're not so sure he measures up. (Larry Greenemeier)
> 


-- 
cordialmente,

Ing. Mario Soto Cordones

In response to

Responses

pgsql-es-ayuda by date

Next:From: Alvaro HerreraDate: 2005-07-26 15:04:37
Subject: Re: Maximo de argumentos en una function
Previous:From: Moises Alberto Lindo GutarraDate: 2005-07-26 15:01:09
Subject: Re: Consulta fuera de topico

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group