Re: number of rows estimation for bit-AND operation

От: Alvaro Herrera
Тема: Re: number of rows estimation for bit-AND operation
Дата: ,
Msg-id: 20090821201225.GN5487@alvh.no-ip.org
(см: обсуждение, исходный текст)
Ответ на: Re: number of rows estimation for bit-AND operation  (Robert Haas)
Список: pgsql-performance

Скрыть дерево обсуждения

number of rows estimation for bit-AND operation  (Slava Moudry, )
 Re: number of rows estimation for bit-AND operation  (Scott Marlowe, )
  Re: number of rows estimation for bit-AND operation  (Slava Moudry, )
 Re: number of rows estimation for bit-AND operation  (Scott Marlowe, )
  Re: number of rows estimation for bit-AND operation  (Slava Moudry, )
 Re: number of rows estimation for bit-AND operation  (Scott Marlowe, )
  Re: number of rows estimation for bit-AND operation  (Robert Haas, )
   Re: number of rows estimation for bit-AND operation  (Slava Moudry, )
 Re: number of rows estimation for bit-AND operation  (Scott Marlowe, )
  Re: number of rows estimation for bit-AND operation  (Scott Marlowe, )
   Re: number of rows estimation for bit-AND operation  (Robert Haas, )
    Re: number of rows estimation for bit-AND operation  (Alvaro Herrera, )
   Re: number of rows estimation for bit-AND operation  (Slava Moudry, )

Robert Haas escribió:

> Scott, did you check whether a toast table got created here and what
> the size of it was?

A table with only bool columns (and, say, one int8 column) would not
have a toast table.  Only varlena columns produce toast tables.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


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

От: Slava Moudry
Дата:
Сообщение: Re: number of rows estimation for bit-AND operation
От: Robert Haas
Дата:
Сообщение: Re: Number of tables