Are there any major benefits to using point and not real data type

Поиск
Список
Период
Сортировка
От romeo407
Тема Are there any major benefits to using point and not real data type
Дата
Msg-id 1445279609353-5870626.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: Are there any major benefits to using point and not real data type  (John R Pierce <pierce@hogranch.com>)
Список pgsql-general
I am using postgres 9.4 and am new to this but I have 2 columns right now
latitudes & longitudes. I have them saved as a real column so they take up 4
bits each 8 altogether. I see that point is used for latitudes and
longitudes but it is a whopping 16 bits are there any benefits (Performance)
of using point over real datatype for coordinates? I plan on using indexes
on the column and do receive a lot of inserts .



--
View this message in context:
http://postgresql.nabble.com/Are-there-any-major-benefits-to-using-point-and-not-real-data-type-tp5870626.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


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

Предыдущее
От: Josip Rodin
Дата:
Сообщение: Re: ERROR: tablespace "archive2" is not empty
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Are there any major benefits to using point and not real data type