| From: | Arnaud Lesauvage <thewild(at)freesurf(dot)fr> |
|---|---|
| To: | Tobias Brox <tobias(at)nordicbet(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Poor performance on very simple query ? |
| Date: | 2006-10-03 12:25:28 |
| Message-ID: | 452256B8.9050607@freesurf.fr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Tobias Brox wrote:
> [Arnaud Lesauvage - Tue at 02:13:59PM +0200]
>> Tobias Brox wrote:
>> >Oh, the gid is not primary key. I guess I should also apologize for
>> >adding noise here :-)
>>
>> Yes, it is a primary key, but I am the noise maker here ! ;-)
>
> Oh - it is. How can you have a default value on a primary key?
Good question, but I am not the DB designer in that case.
> Will it
> use the index if you do "analyze"? Is there an index on the table at
> all, do you get it up if you ask for a description of the table (\d
> tablename)?
In this case (a simplified version of the real case), the pkey is the
only index. It is used if I only as for one row (WHERE gid=33).
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Cottenceau | 2006-10-03 12:27:40 | Re: Poor performance on very simple query ? |
| Previous Message | Tobias Brox | 2006-10-03 12:17:09 | Re: Poor performance on very simple query ? |