On Wed, 23 Jun 2004 13:52:39 -0400 Rod Taylor <[EMAIL PROTECTED]> wrote:
> But yes, doing it via this mailing list is probably the cheapest option.
yes, he just needs to decide how big a hurry he's in.
also, if he does decide to hire a consultant, i suggest he pop over
to pgsql-jobs and ask there
> 2) You can hire a PG database expert.This will be much faster, but cost
> you a lot of money.
I wouldn't exactly say "a lot of money". Lots of consulters out there
are willing to put in a weeks worth of effort, on site, for
significantly less than a support contract with most commercial DB
Bill,
> Ok, so maybe someone on this group will have a better idea. We have a
> database of financial information, and this has literally millions of
> entries. I have installed indicies, but for the rather computationally
> demanding processes we like to use, like a select query to find the
> c
Bill wrote:
> Ok, so maybe someone on this group will have a better idea. We have a
> database of financial information, and this has literally millions of
> entries. I have installed indicies, but for the rather
computationally
> demanding processes we like to use, like a select query to find th
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Bill wrote:
| Ok, so maybe someone on this group will have a better idea. We have a
| database of financial information, and this has literally millions of
| entries. I have installed indicies, but for the rather computationally
| demanding processes
Bill wrote:
Ok, so maybe someone on this group will have a better idea. We have a
database of financial information, and this has literally millions of
entries. I have installed indicies, but for the rather computationally
demanding processes we like to use, like a select query to find the
commod
-performance-
> [EMAIL PROTECTED] On Behalf Of Bill
> Sent: Tuesday, June 22, 2004 1:31 PM
> To: Josh Berkus
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PERFORM] postgresql and openmosix migration
>
> Ok, so maybe someone on this group will have a better idea. We have a
> database
On Tue, 22 Jun 2004 12:31:15 -0500 Bill <[EMAIL PROTECTED]> wrote:
> I have installed indicies,
but are there any statistics? vacuum analyze is your friend
> but for the rather computationally
> demanding processes we like to use, like a select query to find the
> commodity with the highest month
Message -
From: "Josh Berkus" <[EMAIL PROTECTED]>
To: "Bill" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, June 22, 2004 11:31 AM
Subject: Re: [PERFORM] postgresql and openmosix migration
> Bill,
>
> > Any ideas of how I can cluster
On Tue, Jun 22, 2004 at 12:31:15 -0500,
Bill <[EMAIL PROTECTED]> wrote:
> Ok, so maybe someone on this group will have a better idea. We have a
> database of financial information, and this has literally millions of
> entries. I have installed indicies, but for the rather computationally
> dema
ROTECTED]>
To: "Bill" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, June 22, 2004 11:31 AM
Subject: Re: [PERFORM] postgresql and openmosix migration
> Bill,
>
> > Any ideas of how I can cluster my database (around 800 GB
> > in size so even par
Bill,
> Any ideas of how I can cluster my database (around 800 GB
> in size so even partial replication is not really practical)?
Um, raise $150,000 to pay for a clustering implementation?
Various techniques of "shared memory clustering" have been tried with
PostgreSQL, and none work.Neit
12 matches
Mail list logo
