Re: query planner not using the correct index

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Joshua Shanks" <jjshanks@xxxxxxxxx>
Subject: Re: query planner not using the correct index
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Thu, 07 Aug 2008 20:11:14 -0400
Cc: "Craig Ringer" <craig@xxxxxxxxxxxxxxxxxxxxx>, pgsql-performance@xxxxxxxxxxxxxx
Comments: In-reply-to "Joshua Shanks" <jjshanks@xxxxxxxxx> message dated "Thu, 07 Aug 2008 18:55:42 -0500"
In-reply-to: <84f0acdb0808071655s79d0644o21df6b397b3616c0@xxxxxxxxxxxxxx>
References: <84f0acdb0808061435q5ebb607cjc311f1eb4da841a@xxxxxxxxxxxxxx> <489A623A.4090400@xxxxxxxxxxxxxxxxxxxxx> <84f0acdb0808062014p29cf7482ied332225a0a92c63@xxxxxxxxxxxxxx> <489A6AF5.50908@xxxxxxxxxxxxxxxxxxxxx> <84f0acdb0808070811l43a3da9eq240d272f8ddd105c@xxxxxxxxxxxxxx> <27696.1218143560@xxxxxxxxxxxxx> <84f0acdb0808071501n15b0182ga7eca7b1be37d705@xxxxxxxxxxxxxx> <29507.1218152891@xxxxxxxxxxxxx> <84f0acdb0808071655s79d0644o21df6b397b3616c0@xxxxxxxxxxxxxx>

"Joshua Shanks" <jjshanks@xxxxxxxxx> writes:
> How do I increase the stats target for just one column?

Look under ALTER TABLE.

			regards, tom lane

Follow-Ups:
- Re: query planner not using the correct index
  - From: Joshua Shanks

References:
- query planner not using the correct index
  - From: Joshua Shanks
- Re: query planner not using the correct index
  - From: Craig Ringer
- Re: query planner not using the correct index
  - From: Joshua Shanks
- Re: query planner not using the correct index
  - From: Craig Ringer
- Re: query planner not using the correct index
  - From: Joshua Shanks
- Re: query planner not using the correct index
  - From: Tom Lane
- Re: query planner not using the correct index
  - From: Joshua Shanks
- Re: query planner not using the correct index
  - From: Tom Lane
- Re: query planner not using the correct index
  - From: Joshua Shanks

Prev by Date: Re: query planner not using the correct index
Next by Date: Re: Query Plan choice with timestamps
Previous by thread: Re: query planner not using the correct index
Next by thread: Re: query planner not using the correct index
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux