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
On Wed, Mar 16, 2005 at 05:10:17PM -0300, Rodrigo Moreno wrote:
> If I join movest/natope, it's fast, if I join movest/produt, it's fast too,
> but when I put a third joined table, forget, it's very slow.
What version of PostgreSQL are you using?
> All tables are vacuumed by vacummdb --full --an
Hi all,
Could someone explain me when I joined tree tables the querys that took
about 1sec to finish, takes 17secs to complete when I put tree tables joined
?
If I join movest/natope, it's fast, if I join movest/produt, it's fast too,
but when I put a third joined table, forget, it's very slow.
