paulo matadr wrote:
see results:
oid | relname| reltype | reltuples | relpages | size_kb
---+--+-+---+--+-
16506 | cliente_fone | 16507 |341130 | 3345 | 26760
OK, so there is no TOAST table either. I am out of ideas. It's
?
De: Craig Ringer <[EMAIL PROTECTED]>
Para: paulo matadr <[EMAIL PROTECTED]>
Cc: GENERAL
Enviadas: Quinta-feira, 20 de Novembro de 2008 8:09:19
Assunto: Re: Res: Res: Res: [GENERAL] Archive files growth!!!
paulo matadr wrote:
> teste=#
paulo matadr wrote:
teste=# \d cliente_fone
Table "cadastro.cliente_fone"
Column |Type | Modifiers
+ -+
cfon_id| integ
ATE RESTRICT ON DELETE RESTRICT
thanks
De: Craig Ringer <[EMAIL PROTECTED]>
Para: paulo matadr <[EMAIL PROTECTED]>
Cc: GENERAL
Enviadas: Segunda-feira, 17 de Novembro de 2008 21:27:27
Assunto: Re: Res: Res: [GENERAL] Archive files growt
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
result for your query
"cliente_fone" 341130 3345 26760k
De: Craig Ringer <[EMAIL PROTECTED]>
Para: paulo matadr <[EMAIL PROTECTED]>
Cc: GENERAL
Enviadas: Sábado, 15 de Novembro de 2008 5:53:12
Assunto: Re: Res: [GENERAL] Archive files g
paulo matadr wrote:
>
> Let me see, for example one insert type (inser into table2 (select *
> from table1), where table have size 26megas,make 226megas for archives
> files.
> (i made a test with parameter wal_bufffer before this is defaul value
> 64k and the same commando make 640megas of archi
Let me see, for example one insert type (inser into table2 (select * from
table1), where table have size 26megas,make 226megas for archives files.
(i made a test with parameter wal_bufffer before this is defaul value 64k and
the same commando make 640megas of archives after modify to 1024k a tak
