> A lot of data, but not a lot of records... I don't know if that's
> valid. I guess the people at Greenplum and/or Sun have more exciting
> stories ;)
Not really. Pretty much multi-terabyte tables are fine on vanilla
PostgreSQL if you can stick to partitioned and/or indexed access. If you
n
On 19 Jan 2007 at 10:56a -0600, Bruno Wolff III wrote:
On Fri, Jan 19, 2007 at 09:05:35 -0500,
Kevin Hunter <[EMAIL PROTECTED]> wrote:
Seriously though, that would have bitten me. Thank you, I did not know
that. Does that mean that I can't publish the results outside of my
work/research/per
On 1/17/07, Steve <[EMAIL PROTECTED]> wrote:
Hey there;
I've been lurking on this list awhile, and I've been working with postgres
for a number of years so I'm not exactly new to this. But I'm still
having trouble getting a good balance of settings and I'd like to see what
other people think. W
On Fri, Jan 19, 2007 at 09:05:35 -0500,
Kevin Hunter <[EMAIL PROTECTED]> wrote:
>
> Seriously though, that would have bitten me. Thank you, I did not know
> that. Does that mean that I can't publish the results outside of my
> work/research/personal unit at all? Or do I just need to obscure
On 1/18/07, Brian Hurt <[EMAIL PROTECTED]> wrote:
Is there any experience with Postgresql and really huge tables? I'm
talking about terabytes (plural) here in a single table. Obviously the
table will be partitioned, and probably spread among several different
file systems. Any other tricks I s
On 19 Jan 2007 at 8:45a -0500, Merlin Moncure wrote:
On 1/17/07, Kevin Hunter [hunteke∈earlham.edu] wrote:
I am in the process of learning some of the art/science of benchmarking.
Given novnov's recent post about the comparison of MS SQL vs
PostgresQL, I felt it time to do a benchmark compariso
On 1/17/07, Kevin Hunter <[EMAIL PROTECTED]> wrote:
Hello List,
Not sure to which list I should post (gray lines, and all that), so
point me in the right direction if'n it's a problem.
I am in the process of learning some of the art/science of benchmarking.
Given novnov's recent post about th
On Thu, 18 Jan 2007, Tom Lane wrote:
Brian Hurt <[EMAIL PROTECTED]> writes:
Is there any experience with Postgresql and really huge tables? I'm
talking about terabytes (plural) here in a single table.
The 2MASS sky survey point-source catalog
http://www.ipac.caltech.edu/2mass/releases/allsky
