Grokbase
x

Elvis Henríquez (henriquez...@gmail.com)

Profile | Posts (4)

User Information

Display Name:Elvis Henríquez
Partial Email Address:henriquez...@gmail.com
Posts:
4 total
2 in PostgreSQL - Admin
2 in PostgreSQL - ODBC

5 Most Recent

1) Elvis Henríquez Re: Case studies
| +1 vote
That's what I'm telling to them, but they want proven results in other companies, but I'll manage...
PostgreSQL - Admin
[ Profile | Reply to group ] [ Flat  Thread  Threaded ]
That's what I'm telling to them, but they want proven results in other
companies, but I'll manage it.

Thanks for your reply and information.

Best regards.


On Nov 27, 2007 2:12 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> That's actually pretty small. Where I work we have a data warehouse
> of similar design (a few large tables, a few small lookup tables). It
> has 86,840,447 rows and takes up 44 Gigs of space. It sits on a
> single CPU box with a 4 disk RAID-10 and runs queries covering a few
> minutes to a few days worth of monitoring data. Sequential scanning
> the whole main table takes 621 seconds or so (10+ minutes). We add
> 150 to 200k rows a day to it.
>
> Selecting a days's worth of data takes ~ 350ms. A week's worth takes
> 2 to 10 seconds depending on how much is cached.
>
> This is a small database for either oracle or postgresql. Talk your
> bosses into giving postgresql a try if you can. You should be able to
> build a 20million test database in an afternoon or so, so it's not
> like you'll be dedicating thousands of man hours to test it.
>
2) Elvis Henríquez Re: Case studies
| +1 vote
Thank you very much for your reply. That's exactly what I was needing to demonstrate the power of...
PostgreSQL - Admin
[ Profile | Reply to group ] [ Flat  Thread  Threaded ]
Thank you very much for your reply. That's exactly what I was needing
to demonstrate the power of PostgreSQL.


On Nov 27, 2007 1:46 AM, Rodrigo De Le=F3n <rdeleonp@gmail.com> wrote:
> On Nov 26, 2007 10:34 PM, Elvis Henr=EDquez <henriquez.elvis@gmail.com> w=
rote:
> > I hope you could help me with this.
>
> See:
> http://www.lethargy.org/~jesus/archives/66-Big-Bad-PostgreSQL.html
>
3) Elvis Henríquez Case studies
| +1 vote
Hello everybody. Rather than asking for a technical detail or writing about a problem, I'm asking...
PostgreSQL - Advocacy
[ Profile | Reply to group ] [ Flat  Thread  Threaded ]
Hello everybody.

Rather than asking for a technical detail or writing about a problem,
I'm asking for up-to-date case studies involving PostgreSQL.

The company where I'm actually working is migrating some apps; one
requires a Data Warehouse, and I'm proposing PostgreSQL, but they're
thinking of Oracle, as the system has one table (among others) with 20
fields and more then 19 millions of records, and this exists for 2
subcompanies, which are actually in different databases, but the
migration project implies joining the two subcompanies data.

This amount of data is the result of 8 years of usage, and the data
growing rate has increased in the last two years.

They asked me for case studies that shows this, so they can go ahead
with the migration to PostgreSQL.

The ones shown in "http://www.postgresql.org/about/casestudies/" are
out-dated and don't show amount of records or database/table size or
growth.

I hope you could help me with this.
4) Elvis Henríquez Case studies
| +1 vote
Hello everybody. Rather than asking for a technical detail or writing about a problem, I'm asking...
PostgreSQL - Admin
[ Profile | Reply to group ] [ Flat  Thread  Threaded ]
Hello everybody.

Rather than asking for a technical detail or writing about a problem,
I'm asking for up-to-date case studies involving PostgreSQL.

The company where I'm actually working is migrating some apps; one
requires a Data Warehouse, and I'm proposing PostgreSQL, but they're
thinking of Oracle, as the system has one table (among others) with 20
fields and more then 19 millions of records, and this exists for 2
subcompanies, which are actually in different databases, but the
migration project implies joining the two subcompanies data.

This amount of data is the result of 8 years of usage, and the data
growing rate has increased in the last two years.

They asked me for case studies that shows this, so they can go ahead
with the migration to PostgreSQL.

The ones shown in "http://www.postgresql.org/about/casestudies/" are
out-dated and don't show amount of records or database/table size or
growth.

I hope you could help me with this.
5) Elvis Henríquez Time triggered events
| +1 vote
I remember to have read once some time ago something about time triggered events in PostgreSQL,...
PostgreSQL - Admin
[ Profile | Reply to group ] [ Flat  Thread  Threaded ]
I remember to have read once some time ago something about time
triggered events in PostgreSQL, like Oracle's and M$ SqlServer. Is it
already implemented in PostgreSQL ? If so, how could I use it ?

spacer
Profile | Posts (4)
Home > People > Elvis Henríquez