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
Re: [GENERAL] Archive files growth!!!
paulo matadr wrote:
> How the best way to controling fast growth in my Database.
I'm going to assume, based on the config info you quoted and the subject line,
that you mean controlling the size of the archived WAL files on the warm
standby server. I
paulo matadr wrote:
How the best way to controling fast growth in my Database.
I'm going to assume, based on the config info you quoted and the subject
line, that you mean controlling the size of the archived WAL files on
the warm standby server. If that assumption is incorrect, you might wan
How the best way to controling fast growth in my Database.
atually my postgresql.conf have this:
# - Checkpoints -
checkpoint_segments = 15# in logfile segments, min 1, 16MB each
checkpoint_timeout = 5min # range 30s-1h
#checkpoint_warning = 30s # 0 is
10 matches
Mail list logo
