pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedRES: How to improve postgres performace
2+ messages / 2 participants
[nested] [flat]
* RES: How to improve postgres performace
@ 2005-04-18 16:31 Rodrigo Moreno <rodrigo.miguel@terra.com.br>
0 siblings, 1 reply; 2+ messages in thread
From: Rodrigo Moreno @ 2005-04-18 16:31 UTC (permalink / raw)
To: 'Tom Lane' <tgl@sss.pgh.pa.us>; +Cc: pgsql-performance
Tom,
How to check if the value it's enough ? The log generate by vacuum verbose
can help ?
The current values for:
max_fsm_pages = 1048576
max_fsm_relations = 1000
this is enough ?
Regards,
Rodrigo
-----Mensagem original-----
De: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Enviada em: segunda-feira, 18 de abril de 2005 12:58
Para: Rodrigo Moreno
Cc: pgsql-performance@postgresql.org
Assunto: Re: [PERFORM] How to improve postgres performace
"Rodrigo Moreno" <rodrigo.miguel@terra.com.br> writes:
> At this weekend i have started to use pg_autovacuum with default settings.
> I really worried about that, because it's no enough anymore, and users
> claim about performace. But running the vacuumdb full, everthing
> starts to run better again, so i think the problem is not related to a
specific query.
It sounds like you may not have the FSM settings set large enough for your
database. The default settings are only enough for a small DB (perhaps a
few hundred meg).
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: RES: How to improve postgres performace
@ 2005-04-18 17:32 Tom Lane <tgl@sss.pgh.pa.us>
parent: Rodrigo Moreno <rodrigo.miguel@terra.com.br>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2005-04-18 17:32 UTC (permalink / raw)
To: Rodrigo Moreno <rodrigo.miguel@terra.com.br>; +Cc: pgsql-performance
"Rodrigo Moreno" <rodrigo.miguel@terra.com.br> writes:
> The current values for:
> max_fsm_pages = 1048576
> max_fsm_relations = 1000
> this is enough ?
That max_fsm_pages value is enough to cover 8Gb, so it should work OK
for a database disk footprint up to 10 or so Gb. I don't know how many
tables in your installation so I can't say if max_fsm_relations is high
enough, but you can check that by looking at the tail end of the output
of VACUUM VERBOSE. (Or just count 'em ;-))
Offhand these look reasonable, though, so if you are seeing database
bloat over time it probably means you need to tweak your autovacuum
settings. I'm not much of an autovacuum expert, but maybe someone
else can help you there.
You might want to keep track of physical file sizes over a period of
time and try to determine exactly where the bloat is happening.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-04-18 17:32 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-18 16:31 RES: How to improve postgres performace Rodrigo Moreno <rodrigo.miguel@terra.com.br>
2005-04-18 17:32 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox