> We don't attempt to make every possible inference (and I don't think
> you'd like it if we did).
I wasn't really asking you to, either ;))
Just trying to achieve a more in-depth understanding of the way things work.
> This example doesn't
> persuade me that it would be worth expending the cycl
I've known about this tool for a while, but it seems many people do not
know of its existence and I think it would be useful to a lot of people
who have a hard time reading explain analyze output. (And even those
who can read them without blinking.. when you get deep in join hell it
gets tricky
Hi,
I currently have a mysql server running with a database of around 800
gb. The problem is that the server is old (500 MHz Pentium III with 512
MB RAM) and I want to change this to a new server and convert the
existing database to Postgresql on Debian (I assume that Postgresql
offers better perf
* Bill ([EMAIL PROTECTED]) wrote:
> I currently have a mysql server running with a database of around 800
> gb. The problem is that the server is old (500 MHz Pentium III with 512
> MB RAM) and I want to change this to a new server and convert the
> existing database to Postgresql on Debian (I ass
Stephen Frost wrote:
1. It is possible to have some sort of load-balancing through buying
many computers without replication, i.e have one server which has the
databases and then other servers which has no database but just exists
to balance the memory and processor load? (I have hear
On Wed, 2004-06-16 at 13:15, Bill wrote:
> Hi,
> I currently have a mysql server running with a database of around 800
> gb. The problem is that the server is old (500 MHz Pentium III with 512
> MB RAM) and I want to change this to a new server and convert the
> existing database to Postgresql on
* Scott Marlowe ([EMAIL PROTECTED]) wrote:
> On Wed, 2004-06-16 at 13:15, Bill wrote:
> > 2. It is advantageous to buy AMD 64 rather than the Pentium IV?
>
> Yes and no. If having more than 2 gigs of ram is important, 64 bit
> architecures run faster than 32 bit, where having over 2 gigs usually
Borajetta,
The other thing you can do is take a look at your hardware. What are you
running this on? How much RAM? Are other things running on this server as
well?
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)