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

Re: Unique index and estimated rows.

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Kari Lavikka <tuner(at)bdb(dot)fi>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Unique index and estimated rows.
Date: 2004-01-31 01:45:45
Message-ID: 200401301745.45589.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performance
Kari,

>   users:  "users_upper_nick" unique, btree (upper((nick)::text))
>   image:  "image_uid_status" btree (uid, status)

Odd ... when did you last run ANALYZE on "users"?    

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco


In response to

pgsql-performance by date

Next:From: Neil ConwayDate: 2004-01-31 04:35:31
Subject: Re: views?
Previous:From: Tom LaneDate: 2004-01-30 22:40:29
Subject: Re: another query optimization question

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