Re: Hash join on int takes 8..114 seconds

От: Andrus
Тема: Re: Hash join on int takes 8..114 seconds
Дата: ,
Msg-id: 049C2591982D4B2A81E45043922A9656@andrusnotebook
(см: обсуждение, исходный текст)
Ответ на: Re: Hash join on int takes 8..114 seconds  (Alvaro Herrera)
Ответы: Re: Hash join on int takes 8..114 seconds  (Alvaro Herrera)
Список: 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", )

Alvaro,

> 1. vacuum_cost_delay does not affect vacuum full
> 2. vacuum full is always blocking, regardless of settings

So only way is to disable other database acces if vacuum full is required.

> 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 ?

Andrus.

2008-11-19 00:00:48 EET    11728  1 LOG:  autovacuum: processing database
"postgres"
2008-11-19 00:01:48 EET    11729  1 LOG:  autovacuum: processing database
"mydb1"
2008-11-19 00:02:48 EET    11730  1 LOG:  autovacuum: processing database
"emydb1"
2008-11-19 00:03:48 EET    11731  1 LOG:  autovacuum: processing database
"template1"
2008-11-19 00:04:48 EET    11732  1 LOG:  autovacuum: processing database
"testmydb1"
2008-11-19 00:05:48 EET    11733  1 LOG:  autovacuum: processing database
"mydb3"
2008-11-19 00:06:48 EET    11734  1 LOG:  autovacuum: processing database
"postgres"
2008-11-19 00:07:48 EET    11735  1 LOG:  autovacuum: processing database
"mydb1"
2008-11-19 00:08:48 EET    11736  1 LOG:  autovacuum: processing database
"emydb1"
2008-11-19 00:09:48 EET    11737  1 LOG:  autovacuum: processing database
"template1"
2008-11-19 00:10:48 EET    11750  1 LOG:  autovacuum: processing database
"testmydb1"
2008-11-19 00:11:48 EET    11751  1 LOG:  autovacuum: processing database
"mydb3"
2008-11-19 00:12:48 EET    11752  1 LOG:  autovacuum: processing database
"postgres"
2008-11-19 00:13:48 EET    11753  1 LOG:  autovacuum: processing database
"mydb1"
2008-11-19 00:14:48 EET    11754  1 LOG:  autovacuum: processing database
"emydb1"
2008-11-19 00:15:48 EET    11755  1 LOG:  autovacuum: processing database
"template1"
2008-11-19 00:16:48 EET    11756  1 LOG:  autovacuum: processing database
"testmydb1"
2008-11-19 00:17:48 EET    11757  1 LOG:  autovacuum: processing database
"mydb3"
...



В списке pgsql-performance по дате сообщения:

От: Scott Carey
Дата:
Сообщение: Re: Hash join on int takes 8..114 seconds
От: Glyn Astill
Дата:
Сообщение: Perc 3 DC