Forgot to mention that were running post gres 7.4.2
using a dual optiron system and 4gig ram. The results are used by the PHP web
server.
Thanks again
- Original Message -
From:
borajetta
To: [EMAIL PROTECTED]
Sent: Tuesday, July 06, 2004 10:52
AM
Subject: Keywor
I have been trying to get keyword searching quicker
and have now decided to make smaller tables.
I was working with tables of about 50 000 000 rows
but now will use about 1.5million rows, I am using a TSearch2 to find keywords
in the titles column of the rows. I have indexes using a gist i
Frank, thanks for your answer,
This article http://www.linuxjournal.com/print.php?sid=5841 evaluates
performance from a relational database point of view and it concludes
that ext3 is faster.
The articles you provided evaluate filesystems by using basic shell
commands, copy, tar, touch.
I really
Rodrigo,
> Hello there, I'm trying to make sure my postgres 7.4 is running as fast
> as it can in my box.
> ...
> My Software config is:
>
> RedHat 7.3 - 2.4.20-28.7smp Kernel, reporting four processors because of
> hyper threading.
> Postgres 7.4
> Data directory is on a ext3 journaled filesys
Hello there, I'm trying to make sure my postgres 7.4 is running as fast
as it can in my box.
My hardware configuration is:
HP ML-350G3
Dup processor XEON 2.8
Three U320, 1 rpm disks, RAID-5
HP 641 Raid Controller.
1GB RAM
My Software config is:
RedHat 7.3 - 2.4.20-28.7smp Kernel, reporting fo
