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 по дате отправления: