Date Time Arithmetic Speed - Mailing list pgsql-general

From Dennis Gearon
Subject Date Time Arithmetic Speed
Date
Msg-id 673818.40584.qm@web82105.mail.mud.yahoo.com
Whole thread Raw
List 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 by date:

Previous
From: Peter Hunsberger
Date:
Subject: Re: Using Postgres to store genetic data
Next
From: Roy Walter
Date:
Subject: Re: XML import with DTD