Hi,
I have done some performance tests on 1Gb and 4 Gb Databases on a mono
Pentium 4 , 1 Gb RAM, IDE disk, SCSI disks and RAID0 LUN on DAS 5300 on
Linux RedHat 7.3.
In each cases my tests make select, update and insert.
One of them is pgbench. You can find it in Postgres/contrib/pgbench.
The
Any thoughts?
Actually, I ran my tests using tsearch V1. I wonder if there has been
some weird regression between tsearch 1 and 2?
hris
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
On Wed, Nov 26, 2003 at 09:12:30PM -0800, Steve Atkins wrote:
On Thu, Nov 27, 2003 at 12:41:59PM +0800, Christopher Kings-Lynne wrote:
Does anyone have any metrics on how fast tsearch2 actually is?
I tried it on a synthetic dataset of a million documents of a hundred
words each and while
I'v spent a couple days playing with this problem and searching the mailing lists and
docs etc but come up with nothing. Any help would be much appreciated.
Setup is postgres 7.3.2 on redhat 7.1 on a 1.3GHz Athlon machine with 1G pc133 ram and
SCSI.
Here is the same query with the addition of a