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 dir

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

2012-06-07 Thread Benson Jin
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 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 sta

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

2012-06-07 Thread Benson Jin
drian Klaver" To: "Benson Jin" 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 befo

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 histor

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 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. > Because of the

[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 i