Re: 4 way JOIN using aliases

Список
Период
Сортировка
От Dave Held
Тема Re: 4 way JOIN using aliases
Дата
Msg-id 49E94D0CFCD4DB43AFBA928DDD20C8F9026184A9@asg002.asg.local
обсуждение исходный текст
Ответ на 4 way JOIN using aliases  ("Keith Worthington")
Ответы Re: 4 way JOIN using aliases  ("Keith Worthington")
Список pgsql-performance
Дерево обсуждения
4 way JOIN using aliases  ("Keith Worthington", )
 Re: 4 way JOIN using aliases  (Josh Berkus, )
 Re: 4 way JOIN using aliases  (Neil Conway, )
  Re: 4 way JOIN using aliases  (Keith Worthington, )
 Re: 4 way JOIN using aliases  ("Dave Held", )
  Re: 4 way JOIN using aliases  ("Keith Worthington", )
 Re: 4 way JOIN using aliases  ("Dave Held", )
> -----Original Message-----
> From: Keith Worthington [mailto:]
> Sent: Monday, April 11, 2005 7:44 PM
> To: Neil Conway
> Cc: PostgreSQL Perform
> Subject: Re: [PERFORM] 4 way JOIN using aliases
>
> Neil Conway wrote:
> > Keith Worthington wrote:
> >
> >>               ->  Seq Scan on tbl_current
> (cost=0.00..1775.57 rows=76457
> >> width=31) (actual time=22.870..25.024 rows=605 loops=1)
> >
> >
> > This rowcount is way off -- have you run ANALYZE recently?
> > [...]
>
> I run vacuumdb with the analyze option every morning via a
> cron job.  In my ignorance I do not know if that is the same
> thing.

Pass it an --analyze option if you aren't already.

__
David B. Held
Software Engineer/Array Services Group
200 14th Ave. East,  Sartell, MN 56377
320.534.3637 320.253.7800 800.752.8129

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Dave Held"
Дата:
Сообщение: Re: 4 way JOIN using aliases
Следующее
От: Chris Browne
Дата:
Сообщение: Re: performance hit for replication