Re: Stock Market Price Data & postgreSQL? HELLPPP Please

From: Sanjay Arora <sanjay(dot)k(dot)arora(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Stock Market Price Data & postgreSQL? HELLPPP Please
Date: 2009-08-19 22:17:17
Message-ID: 7e41ba8f0908191517q3720ff23s113fab88d324aa03@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 Lane<tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Sanjay Arora <sanjay(dot)k(dot)arora(at)gmail(dot)com> writes:

>  It might be worth managing your
> tick data using DBMS entries that represent, say, monthly tick data
> files.  Activities like removing old data would get a lot easier that
> way.  (I wish this had occurred to me twelve years ago, but it's water
> over the dam now.)

Do you mean something like storing one month worth tick data in a blob
type field and giving the contents to the CEP engine for further
building of required data streams? This approach would allow getting
big chunks of data to be handled with not caring location, naming &
indexing etc. of tick data files? Anything else you can suggest?

Best Regards.
Sanjay.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-08-19 22:53:21 Re: Stock Market Price Data & postgreSQL? HELLPPP Please
Previous Message David Fetter 2009-08-19 22:08:53 Re: Postgre RAISE NOTICE and PHP