Output:
teste=# \d cliente_fone
Table "cadastro.cliente_fone"
Column | Type | Modifiers
------------------------+---------------- -------------+------------------------
cfon_id | integer | not null
clie_id | integer | not null
cfon_cdddd | character(2) |
cfon_nnfone | character varying(9) |
cfon_nnfoneramal | character varying(4) |
cfon_icfonepadrao | smallint |
fnet_id | integer | not null
cfon_tmultimaalteracao | timestamp without time zone | not null default now()
cfon_nmcontato | character varying(50) |
Indexes:
"cliente_fone_pkey" PRIMARY KEY, btree (cfon_id)
Foreign-key constraints:
"cliente_fone_clie_id_fkey" FOREIGN KEY (clie_id) REFERENCES
cliente(clie_id) ON UPDATE RESTRICT ON DELETE RESTRICT
"cliente_fone_fnet_id_fkey" FOREIGN KEY (fnet_id) REFERENCES
fone_tipo(fnet_id) ON UPDATE RESTRICT ON DELETE RESTRICT
thanks
________________________________
De: Craig Ringer <[EMAIL PROTECTED]>
Para: paulo matadr <[EMAIL PROTECTED]>
Cc: GENERAL <pgsql-general@postgresql.org>
Enviadas: Segunda-feira, 17 de Novembro de 2008 21:27:27
Assunto: Re: Res: Res: [GENERAL] Archive files growth!!!
paulo matadr wrote:
>
> result for your query
>
> "cliente_fone" 341130 3345 26760k
OK. And what about indexes, logging triggers, etc?
Can you post the output of:
\d client_fone
from psql?
(I can't really imagine how indexes alone could generate that much
logging data, though).
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com