Postgres Pro
Downloads
Home   >   mailing lists

Re: Unique index and estimated rows. - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Unique index and estimated rows.
Date
Msg-id 200401301745.45589.josh@agliodbs.com
Whole thread Raw
In response to Unique index and estimated rows.  (Kari Lavikka <tuner@bdb.fi>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Neil Conway
Date:
Subject: Re: views?
Next
From: Tom Lane
Date:
Subject: Re: High Performance/High Reliability File system on SuSE64