ime
and try to determine exactly where the bloat > is happening.
There is two mostly used and bigger tables, I'll keep eyes on both tables.
Thanks
Rodrigo Moreno
---(end of broadcast)---
TIP 8: explain analyze is your friend
gunda-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" <[EMAIL PROTECTED]> writes:
> At this weekend i have started to use pg_autovacuum with default settings.
t = 2
stats_start_collector = true
stats_row_level = true
I follow the most of all discussions in this group and tried myself change
the parameters, but now, I don't know more what to do to get better
performance.
Thanks a Lot
Rodrigo Moreno
---(end of
em: quinta-feira, 17 de março de 2005 01:42
Para: Rodrigo Moreno
Cc: pgsql-performance@postgresql.org
Assunto: Re: [PERFORM] Help to find out problem with joined tables
On Wed, Mar 16, 2005 at 05:10:17PM -0300, Rodrigo Moreno wrote:
> If I join movest/natope, it's fast, if I join moves
t;-> Sort (cost=3.65..3.82 rows=66 width=4) (actual
time=1.114..1.209 rows=49 loops=1)"
" Sort Key: (b.natope_id)::numeric"
" -> Seq Scan on natope b (cost=0.00..1.66 rows=66 width=4)
(actual time=0.058..0.485 rows=66 loops=1)"
" -> Seq Scan on produt c (cost=0.00..108.26 rows=8 width=4) (actual
time=2688.356..2875.743 rows=1 loops=6)"
"Filter: ((codpro)::numeric = 629001::numeric)"
"Total runtime: 17257.865 ms"
Best Regards
Rodrigo Moreno
---(end of broadcast)---
TIP 8: explain analyze is your friend
l perform analyze in each query
in procedure.
When i get more results, i post here.
Thanks a Lot
Rodrigo Moreno
---(end of broadcast)---
TIP 8: explain analyze is your friend
feira, 18 de fevereiro de 2005 12:00
Para: Rodrigo Moreno
Cc: pgsql-performance@postgresql.org
Assunto: Re: RES: [PERFORM] Degradation of postgres 7.4.5 on
FreeBSD/CygWin
"Rodrigo Moreno" <[EMAIL PROTECTED]> writes:
> max_fsm_pages = 4
> max_fsm_relations = 2000
&
rt on 900mb ?
Both customer are smaller databases, but one of them, has 8 years os data,
it's the reason of size 900mb, these are too smaller database.
Regards
Rodrigo Moreno
---(end of broadcast)---
TIP 8: explain analyze is your friend
l to my customer that he is having the same problem that in cygwin
version, after spending money to change from windows to freebsd,upgrading
server, etc, problably he will kill me. :)
Best Regards
Rodrigo Moreno
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
