Re: Database slowness -- my design, hardware, or both? - Mailing list pgsql-general

From Reuven M. Lerner
Subject Re: Database slowness -- my design, hardware, or both?
Date
Msg-id 45ED9908.20401@lerner.co.il
Whole thread Raw
In response to Re: Database slowness -- my design, hardware, or both?  ("Webb Sprague" <webb.sprague@gmail.com>)
Responses Re: Database slowness -- my design, hardware, or both?  ("Webb Sprague" <webb.sprague@gmail.com>)
List pgsql-general
Hi, Webb Sprague.  You wrote:
> How much concurrency is there on your database?
Almost none.  I'm generally running one client against the server.  I
often have a second client connected simultaneously, just for the
purpose of answering short questions.

I'm now thinking of separating each activity into its own database, in
the hopes that this will improve the system speed enough to do what I
need.  But I'm far from convinced that this will really help.

Reuven


pgsql-general by date:

Previous
From: MargaretGillon@chromalloy.com
Date:
Subject: Re: M:M table conditional delete for parents
Next
From: Laurent ROCHE
Date:
Subject: Re : Importing *huge* mysql database into pgsql