Date Time Arithmetic Speed

Поиск
Список
Период
Сортировка
От Dennis Gearon
Тема Date Time Arithmetic Speed
Дата
Msg-id 673818.40584.qm@web82105.mail.mud.yahoo.com
обсуждение исходный текст
Список pgsql-general
I have an application that I am working on that may do some regular, cron generated time date conversions.

It would do:
     DATE + TIME = TIMESTAMP.

It would do a LOT of thesebut spread out over every day to keep the load down and allow the server to do it's may job,
dishout the results. 

What are the tradeoffs in storage space, indexed query speed of the DATE and TIME formats, and speed of the math for
thevarious for the combinations of DATE and TIME that would be possible to derive timestamps from? 


Dennis Gearon

Signature Warning
----------------
EARTH has a Right To Life

I agree with Bolivian President Evo Morales

# The right to life: "The right for no ecosystem to be eliminated by the irresponsible acts of human beings."

# The right of biosystems to regenerate themselves: "Development cannot be infinite. There's a limit on everything."

# The right to a clean life: "The right for Mother Earth to live without contamination, pollution. Fish and animals and
treeshave rights." 

# The right to harmony and balance between everyone and everything: "We are all interdependent."


See the movie - 'Inconvenient Truth'
See the movie - 'Syriana'

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

Предыдущее
От: Peter Hunsberger
Дата:
Сообщение: Re: Using Postgres to store genetic data
Следующее
От: Roy Walter
Дата:
Сообщение: Re: XML import with DTD