Re: Hash join on int takes 8..114 seconds
| От | PFC |
|---|---|
| Тема | Re: Hash join on int takes 8..114 seconds |
| Дата | |
| Msg-id | op.ukv3hnsfcigqcu@soyouz обсуждение исходный текст |
| Ответ на | Hash join on int takes 8..114 seconds ("Andrus") |
| Ответы |
Re: Hash join on int takes 8..114 seconds
("Andrus")
|
| Список | pgsql-performance |
Дерево обсуждения
Hash join on int takes 8..114 seconds
("Andrus",
)
Re: Hash join on int takes 8..114 seconds (PFC, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
Re: Hash join on int takes 8..114 seconds (Richard Huxton, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
Re: Hash join on int takes 8..114 seconds (Richard Huxton, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
Re: Hash join on int takes 8..114 seconds (PFC, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
Re: Hash join on int takes 8..114 seconds (, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
Re: Hash join on int takes 8..114 seconds (PFC, )
Re: Hash join on int takes 8..114 seconds (Alan Hodgson, )
Re: Hash join on int takes 8..114 seconds (Tomas Vondra, )
Re: Hash join on int takes 8..114 seconds (Richard Huxton, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
Re: Hash join on int takes 8..114 seconds (PFC, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
Re: Hash join on int takes 8..114 seconds (Alvaro Herrera, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
Re: Hash join on int takes 8..114 seconds (Alvaro Herrera, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
Re: Hash join on int takes 8..114 seconds (Alvaro Herrera, )
Re: Hash join on int takes 8..114 seconds (Tomas Vondra, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
Re: Hash join on int takes 8..114 seconds (Scott Carey, )
Re: Hash join on int takes 8..114 seconds (PFC, )
Re: Hash join on int takes 8..114 seconds (Tom Lane, )
Re: Hash join on int takes 8..114 seconds (PFC, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
Re: Hash join on int takes 8..114 seconds (PFC, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
Re: Hash join on int takes 8..114 seconds (Tomas Vondra, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
Re: Hash join on int takes 8..114 seconds (Tomas Vondra, )
Re: Hash join on int takes 8..114 seconds (Scott Carey, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
Re: Hash join on int takes 8..114 seconds (Tomas Vondra, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
Re: Hash join on int takes 8..114 seconds (, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
Re: Hash join on int takes 8..114 seconds (PFC, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
Re: Hash join on int takes 8..114 seconds (Richard Huxton, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
Re: Hash join on int takes 8..114 seconds (Richard Huxton, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
Re: Hash join on int takes 8..114 seconds (PFC, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
Re: Hash join on int takes 8..114 seconds (, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
Re: Hash join on int takes 8..114 seconds (PFC, )
Re: Hash join on int takes 8..114 seconds (Alan Hodgson, )
Re: Hash join on int takes 8..114 seconds (Tomas Vondra, )
Re: Hash join on int takes 8..114 seconds (Richard Huxton, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
Re: Hash join on int takes 8..114 seconds (PFC, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
Re: Hash join on int takes 8..114 seconds (Alvaro Herrera, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
Re: Hash join on int takes 8..114 seconds (Alvaro Herrera, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
Re: Hash join on int takes 8..114 seconds (Alvaro Herrera, )
Re: Hash join on int takes 8..114 seconds (Tomas Vondra, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
Re: Hash join on int takes 8..114 seconds (Scott Carey, )
Re: Hash join on int takes 8..114 seconds (PFC, )
Re: Hash join on int takes 8..114 seconds (Tom Lane, )
Re: Hash join on int takes 8..114 seconds (PFC, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
Re: Hash join on int takes 8..114 seconds (PFC, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
Re: Hash join on int takes 8..114 seconds (Tomas Vondra, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
Re: Hash join on int takes 8..114 seconds (Tomas Vondra, )
Re: Hash join on int takes 8..114 seconds (Scott Carey, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
Re: Hash join on int takes 8..114 seconds (Tomas Vondra, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
Re: Hash join on int takes 8..114 seconds (, )
Re: Hash join on int takes 8..114 seconds ("Andrus", )
> Query below seems to use indexes everywhere in most optimal way.
> dokumnr column is of type int
>
> Speed of this query varies rapidly:
>
> In live db fastest response I have got is 8 seconds.
> Re-running same query after 10 seconds may take 60 seconds.
> Re-running it again after 10 seconds may take 114 seconds.
>
> Any idea how to speed it up ?
>
> Is it possible to optimize it, will upgrading to 8.3.5 help or should I
> require to add more RAM, disk or CPU speed ?
>
> Real query contains column list instead of sum(1) used in test below.
>
> Andrus.
Just a question, what are you doing with the 20.000 result rows ?
В списке pgsql-performance по дате отправления: