Re: 7.4 - FK constraint performance
От
Tom Lane
Тема
Re: 7.4 - FK constraint performance
Дата
Msg-id
27696.1076647796@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
CHAR(n) always trims trailing spaces in 7.4 "news.postgresql.org" <jlim@natsoft.com.my>
Re: CHAR(n) always trims trailing spaces in 7.4 Tom Lane <tgl@sss.pgh.pa.us>
Re: CHAR(n) always trims trailing spaces in 7.4 elein <elein@varlena.com>
Re: CHAR(n) always trims trailing spaces in 7.4 Tom Lane <tgl@sss.pgh.pa.us>
Re: CHAR(n) always trims trailing spaces in 7.4 elein <elein@varlena.com>
Re: CHAR(n) always trims trailing spaces in 7.4 "scott.marlowe" <scott.marlowe@ihs.com>
Re: CHAR(n) always trims trailing spaces in 7.4 <terry@ashtonwoodshomes.com>
Re: CHAR(n) always trims trailing spaces in 7.4 Tom Lane <tgl@sss.pgh.pa.us>
Re: CHAR(n) always trims trailing spaces in 7.4 Richard Huxton <dev@archonet.com>
Re: CHAR(n) always trims trailing spaces in 7.4 Tom Lane <tgl@sss.pgh.pa.us>
Re: CHAR(n) always trims trailing spaces in 7.4 "Jeremy Smith" <jer@highboard.com>
Inserting NULL into Integer column "Jeremy Smith" <jer@highboard.com>
Re: Inserting NULL into Integer column "scott.marlowe" <scott.marlowe@ihs.com>
Re: Inserting NULL into Integer column "Jeremy Smith" <jer@highboard.com>
Re: Inserting NULL into Integer column "scott.marlowe" <scott.marlowe@ihs.com>
Re: Inserting NULL into Integer column Rod Taylor <pg@rbt.ca>
Re: Inserting NULL into Integer column "scott.marlowe" <scott.marlowe@ihs.com>
Re: Inserting NULL into Integer column Rod Taylor <pg@rbt.ca>
Re: Inserting NULL into Integer column "scott.marlowe" <scott.marlowe@ihs.com>
Re: Inserting NULL into Integer column "Jeremy Smith" <jer@highboard.com>
Re: Inserting NULL into Integer column "scott.marlowe" <scott.marlowe@ihs.com>
Re: CHAR(n) always trims trailing spaces in 7.4 elein <elein@varlena.com>
Re: CHAR(n) always trims trailing spaces in 7.4 Tom Lane <tgl@sss.pgh.pa.us>
Re: CHAR(n) always trims trailing spaces in 7.4 elein <elein@varlena.com>
Re: CHAR(n) always trims trailing spaces in 7.4 Tom Lane <tgl@sss.pgh.pa.us>
Re: CHAR(n) always trims trailing spaces in 7.4 elein <elein@varlena.com>
Re: CHAR(n) always trims trailing spaces in 7.4 Tom Lane <tgl@sss.pgh.pa.us>
ow writes: > --- Tom Lane wrote: >> Can't see how we optimize your case without pessimizing more-common cases. > I think other RDBMSs simply use preset value instead of partial table > scan when there's not enough stat info. Might be a better way. The problem here cannot be described as "not enough stat info". The available stats are complete and they point very strongly to the conclusion that searches in the large table should be seqscans. To do otherwise would be folly in general, even if it happens to be the correct thing in this particular example. regards, tom lane
В списке pgsql-sql по дате отправления
