Re: Hash join on int takes 8..114 seconds
От | Alvaro Herrera |
---|---|
Тема | Re: Hash join on int takes 8..114 seconds |
Дата | |
Msg-id | 20081121191646.GH5210@alvh.no-ip.org обсуждение исходный текст |
Ответ на | Re: 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", )
Andrus wrote: > I discovered vacuum_cost_delay=2000 option. Will this remove blocking > issue and allow vacuum full to work ? No. Are you really using vacuum_cost_delay=2000? If so, therein lies your problem. That's a silly value to use for that variable. Useful values are in the 20-40 range probably, or maybe 10-100 being extremely generous. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
В списке pgsql-performance по дате отправления: