Re: postgresql and openmosix migration

From: Richard Welty <rwelty(at)averillpark(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: postgresql and openmosix migration
Date: 2004-06-22 18:08:10
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-performance

On Tue, 22 Jun 2004 12:31:15 -0500 Bill <bill(at)math(dot)uchicago(dot)edu> 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 monthly or annual returns, the computer generally
> runs unacceptably slow. So, other than clustring, how could I achieve a
> speed increase in these complex queries?

1) have you gone to the effort to tune the values in postgresql.conf?

2) have you tried using explain to find out what the query planner is
up to?

> Is this better in mysql or
> postgresql?

if there is any complexity to the queries, postgresql will serve you better
if you learn how to use it properly.

Richard Welty rwelty(at)averillpark(dot)net
Averill Park Networking 518-573-7592
Java, PHP, PostgreSQL, Unix, Linux, IP Network Engineering, Security

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Shea,Dan [CIS] 2004-06-22 18:42:56 after using pg_resetxlog, db lost
Previous Message jason.servetar 2004-06-22 17:58:39 Re: postgresql and openmosix migration