Re: Hash join on int takes 8..114 seconds
От | Alvaro Herrera |
---|---|
Тема | Re: Hash join on int takes 8..114 seconds |
Дата | |
Msg-id | 20081121202036.GK5210@alvh.no-ip.org обсуждение исходный текст |
Ответ на | 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: >> So I gather you're not doing any vacuuming, eh? > > Log files for every day are full of garbage messages below. > So I hope that vacuum is running well, isn't it ? This does not really mean that autovacuum has done anything in the databases. If the times are consistently separated by 1 min, then it's possible that it always exits without doing anything. In such old a release we didn't have any decent logging mechanism in autovacuum :-( You can change log_min_messages to debug2 to see if it actually does anything or not. I suggest you connect to the problem database (and then to all others, just to be sure) and run "vacuum" (no full). -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
В списке pgsql-performance по дате отправления: