Re: [GENERAL] Need help in transferring FP to Int64 DateTime

2012-06-07 Thread Benson Jin
adrian.kla...@gmail.com To: Benson Jin benson@troo.com Cc: pgsql-general@postgresql.org Sent: Wednesday, June 6, 2012 10:02:02 PM Subject: Re: [GENERAL] Need help in transferring FP to Int64 DateTime On 06/06/2012 09:20 AM, Benson Jin wrote: Hi All, I am sure this question has been asked

Re: [GENERAL] Need help in transferring FP to Int64 DateTime

2012-06-07 Thread Benson Jin
, 2012 8:01:35 PM Subject: Re: [GENERAL] Need help in transferring FP to Int64 DateTime On Wed, Jun 6, 2012 at 9:20 AM, Benson Jin benson@troo.com wrote: I am sure this question has been asked before, however, I failed to find any related topics in the internet. We have a database about 100GB

Re: [GENERAL] Need help in transferring FP to Int64 DateTime

2012-06-07 Thread Adrian Klaver
On 06/07/2012 08:29 AM, Benson Jin wrote: Hi Adrian, Thanks for the suggestion! We thought about that too, but concerned about the possible performance penalty trigger based replication would bring. If there is no other alternative, we will give your suggestion a try... AFAIK there is no

[GENERAL] Need help in transferring FP to Int64 DateTime

2012-06-06 Thread Benson Jin
Hi All, I am sure this question has been asked before, however, I failed to find any related topics in the internet. We have a database about 100GB in size. It was started back in 7.x days and has been upgraded along the way to 9.0. Because of the historical reason, all timestamps are stored

Re: [GENERAL] Need help in transferring FP to Int64 DateTime

2012-06-06 Thread Josh Kupershmidt
On Wed, Jun 6, 2012 at 9:20 AM, Benson Jin benson@troo.com wrote: I am sure this question has been asked before, however, I failed to find any related topics in the internet. We have a database about 100GB in size. It was started back in 7.x days and has been upgraded along the way to 9.0.

Re: [GENERAL] Need help in transferring FP to Int64 DateTime

2012-06-06 Thread Adrian Klaver
On 06/06/2012 09:20 AM, Benson Jin wrote: Hi All, I am sure this question has been asked before, however, I failed to find any related topics in the internet. We have a database about 100GB in size. It was started back in 7.x days and has been upgraded along the way to 9.0. Because of the