Skip site navigation (1) Skip section navigation (2)

Re: number of rows estimation for bit-AND operation

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>,Slava Moudry <smoudry(at)4info(dot)net>,"pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: number of rows estimation for bit-AND operation
Date: 2009-08-21 20:12:25
Message-ID: 20090821201225.GN5487@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

pgsql-performance by date

Next:From: Robert HaasDate: 2009-08-23 00:40:32
Subject: Re: Number of tables
Previous:From: Robert HaasDate: 2009-08-21 20:04:23
Subject: Re: number of rows estimation for bit-AND operation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group