[ADMIN] ERROR: index_formtuple: data takes 40 bytes, max is 8191

2002-06-28 Thread Simone Tellini
I get an error like this every time I try to modify a database (with update/insert/drop index...) What's happened? Can I fix it? how? It's postgres 7.1.3, btw -- Simone Tellini E-mail: [EMAIL PROTECTED] http://www.areabusiness.it ---(end of broadcast)--

Re: [ADMIN] Are statistics gathered on function indexes?

2002-06-28 Thread Curt Sampson
The vast majority of the cost of using an index is due to reading the data blocks in the table in a random order, rathern than sequentially, right? Rather than making estimates of the selectivity of an index when you search for 'W%', why not actually start the index lookup and count how many you