Hi,
We noticed a slowdown on our application while traffic was kinda
heavy. The logics after reading the docs commanded us to trim the
enlarged tables, run VACUUM ANALYZE and then expect fast
performance again; but it wasn't the case[1].
Out of the blue, we dumped the database, removed it,
Hi, Guillaume
Guillaume Cottenceau wrote:
We noticed a slowdown on our application while traffic was kinda
heavy. The logics after reading the docs commanded us to trim the
enlarged tables, run VACUUM ANALYZE and then expect fast
performance again; but it wasn't the case[1].
What exactly do
Hi Markus,
Thanks for your message.
Guillaume Cottenceau wrote:
We noticed a slowdown on our application while traffic was kinda
heavy. The logics after reading the docs commanded us to trim the
enlarged tables, run VACUUM ANALYZE and then expect fast
performance again; but it wasn't
Guillaume,
On 28 Aug 2006 11:43:16 +0200, Guillaume Cottenceau [EMAIL PROTECTED] wrote:
max_fsm_pages is 2
max_fsm_relations is 1000
Do they look low?
Yes they are probably too low if you don't run VACUUM on a regular
basis and you have a lot of UPDATE/DELETE activity. FSM doesn't take
Hi, Guillaume,
Guillaume Cottenceau wrote:
We have a couple of logs files which get larger over time
(millions of rows). As they are log files, they can be trimmed
from older values.
Ah, ok, you DELETEd the old rows.
So I assume that you never UPDATE, but only INSERT new entries and
Guillaume,
Thanks for your help.
On 28 Aug 2006 11:43:16 +0200, Guillaume Cottenceau [EMAIL PROTECTED] wrote:
max_fsm_pages is 2
max_fsm_relations is 1000
Do they look low?
Yes they are probably too low if you don't run VACUUM on a regular
basis and you have a lot of
We have a couple of logs files which get larger over time
(millions of rows). As they are log files, they can be trimmed
from older values.
Ah, ok, you DELETEd the old rows.
Yes.
So I assume that you never UPDATE, but only INSERT new entries and
sometimes DELETE a big bunch of
Hi, Guillaume,
Guillaume Cottenceau wrote:
About REINDEX: is it ok to consider that REINDEX is to indexes
what VACUUM FULL is to table data, because it cleans up unused
index pages?
Yes, roughly speaking.
And AFAICS you're not running it on a regular basis so your database
was probably
Markus Schaber schabi 'at' logix-tt.com writes:
VACUUM ANALYZE is normally run overnight (each night). Is it not
regular enough? There can be hundreds of thousands of statements
a day.
Which PostgreSQL version are you using? Maybe you should consider
autovacuum (which is a contrib