Re: int2 vs int4 in Postgres

Поиск
Список
Период
Сортировка
От Chris Browne
Тема Re: int2 vs int4 in Postgres
Дата
Msg-id 607jd3lcwo.fsf@dba2.int.libertyrms.com
обсуждение исходный текст
Ответ на int2 vs int4 in Postgres  ("Announce" <truthhurts@insightbb.com>)
Список pgsql-performance
truthhurts@insightbb.com ("Announce") writes:
> I KNOW that I am not going to have anywhere near 32,000+ different
> genres in my genre table so why use int4?  Would that squeeze a few
> more milliseconds of performance out of a LARGE song table query
> with a genre lookup?

By the way, I see a lot of queries on tables NOT optimized in this
fashion that run in less than a millisecond, so it would seem
remarkable to me if there were milliseconds to be squeezed out in the
first place...
--
output = reverse("moc.enworbbc" "@" "enworbbc")
http://www.ntlug.org/~cbbrowne/sap.html
Why do we drive on parkways and park on driveways?

В списке pgsql-performance по дате отправления:

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: int2 vs int4 in Postgres
Следующее
От: Chris Browne
Дата:
Сообщение: Re: int2 vs int4 in Postgres