[EMAIL PROTECTED] wrote:
my data base is very slow. The machine is a processor Xeon 2GB with
256 MB of RAM DDR. My archive of configuration is this:
This is a joke, right?
chris
---(end of broadcast)---
TIP 6: Have you searched our list archives
On Thu, 2004-02-05 at 00:32, Christopher Browne wrote:
> > Things of note that might matter: the machine is a dual Opteron
> > 1.4GHz running Fedora Core 1 Test 1 for X86_64. The 7.3.4 was from
> > the Fedora distro and the 7.4.1 was the PGDG package. The database
> > is 3.5 Gigs with 10 millions
Put it on a RAM disk.
chris
On Tue, 2004-02-03 at 07:54, David Teran wrote:
> Hi,
>
> we are trying to speed up a database which has about 3 GB of data. The
> server has 8 GB RAM and we wonder how we can ensure that the whole DB
> is read into RAM. We hope that this will speed up some queries
Actually, it would appear that I was born yesterday. I had no idea.
Added the cast and it fell right in. Thanks!
chris <-- feeling pretty dumb right now
On Sat, 2004-01-03 at 00:57, Tom Lane wrote:
> Chris Trawick <[EMAIL PROTECTED]> writes:
> > contactid |
I tried searching the archives to find something like this. The search
function doesn't like me much, and believe me the feeling is mutual. So
I'm forced to pollute your inboxes with yet another "why the hell isn't
this thing using my index" email. I apologize in advance.
I have a many-to-many
