[GENERAL] Stock Market Price Data postgreSQL? HELLPPP Please

2009-08-19 Thread Sanjay Arora
Hello All I want to store stock market price data in postgreSQL and some of my associates are saying this is not workable, not only in postgreSQL but in any database. Arguments given are listed below. Kindly comment and if possible suggest solutions and pointers to further reading. - This is

Re: [GENERAL] Stock Market Price Data postgreSQL? HELLPPP Please

2009-08-19 Thread Sanjay Arora
On Thu, Aug 20, 2009 at 2:45 AM, Merlin Moncuremmonc...@gmail.com wrote: I think your first step is to stand back, think about the problem as a whole and see if you can't define your requirements better: *) how much data comes in each day? how much rolls out? Need to get some data...will

Re: [GENERAL] Stock Market Price Data postgreSQL? HELLPPP Please

2009-08-19 Thread Sanjay Arora
On Thu, Aug 20, 2009 at 3:11 AM, Adrian Klaverakla...@comcast.net wrote: In the its a small world category I just ran across a streaming database called Telegraph(http://telegraph.cs.berkeley.edu/telegraphcq/v2.1/) yesterday. It is based on Postgres 7.3.2, so approach with caution. Thanks

Re: [GENERAL] Stock Market Price Data postgreSQL? HELLPPP Please

2009-08-19 Thread Sanjay Arora
Thanks Tom For this reply and many earlier ones that have guided me around postgres ;-) On Thu, Aug 20, 2009 at 3:34 AM, Tom Lanet...@sss.pgh.pa.us wrote: Sanjay Arora sanjay.k.ar...@gmail.com writes:  It might be worth managing your tick data using DBMS entries that represent, say, monthly

Re: [GENERAL] Stock Market Price Data postgreSQL? HELLPPP Please

2009-08-19 Thread Sanjay Arora
On Thu, Aug 20, 2009 at 4:23 AM, Tom Lanet...@sss.pgh.pa.us wrote: It does sound like you are doing pretty much exactly what we were doing.  One thing to think about is that the real-time case is actually much slower and easier to deal with than back-testing.  When you are back-testing, you'd

Re: [GENERAL] postgreSQL amazon ec2 cloud

2009-03-18 Thread Sanjay Arora
Thanks Stuart I will try Ubuntu image at Amazon cloud. Seems..they are looking for testers too. Not much of tester, but will be able to at least post to list if something fails ;-) Will try centos after that. With best regards. Sanjay Arora. On Tue, Mar 17, 2009 at 12:10 PM, Stuart Bishop stu

Re: [GENERAL] postgreSQL amazon ec2 cloud

2009-03-03 Thread Sanjay Arora
I found today that postgres EnterpriseDB supports Amazon EC2. On a shoestring budget EnterpriseDB is just as much an option as Oracle ;-( So, question is what makes EnterpriseDB more suitable for the cloud than plain vanilla postgreSQL? Anyone? With best regards. Sanjay. On Tue, Mar 3, 2009

[GENERAL] postgreSQL amazon ec2 cloud

2009-03-02 Thread Sanjay Arora
Hello all Is it possible to host postgreSQL on Amazon's cloud? What are the issues involved? With best regards. Sanjay.

[GENERAL] Attn. PostgreSQL.org webmasters: Site Link not working

2006-02-21 Thread Sanjay Arora
Page: http://www.postgresql.org/docs/faqs.FAQ.htmlSection 2.3 GUI Tools Link http://techdocs.postgresql.org/guides/GUITools Proxy ErrorThe proxy server received an invalid response from an upstream server.The proxy server could not handle the request GET /guides/GUITools.Reason: Could not connect

[GENERAL] RPM for whitebox linux - RH ES3 Clone

2005-03-08 Thread Sanjay Arora
Hi Can someone please tell me if where rpm files for pgsql 8.1 for RH-ES3/whitbox linux can be found? Or do I have to compile? With best Rgds. Sanjay. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command

[GENERAL] Re: VACUUM and 24/7 database operation

2001-01-23 Thread Sanjay Arora
Tom, Shouldn't it be possible to build vacuum as an ongoing internal PG process, instead of a seperate operation? How does Oracle byepass this? Must be some way that can be implemented. Any pointers to further reading to brush up my theory in this regard please? IAC, regarding the actual