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
OTECTED]
Subject: Re: [PERFORM] postgresql and openmosix migration
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
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
Hi, I am trying to make a cluster out of any
database, postgresql or mysql or any other free database. I have looked at
openmosix patched with the migshm patch for shared memory support and it seems
that neither work fully. Postgresql in particular uses "shared memory but
not the system se
13 matches
Mail list logo