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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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