Re: [PERFORM] very large db performance question

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

Re: [PERFORM] For full text indexing, which is better, tsearch2 or

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

Re: [PERFORM] For full text indexing, which is better, tsearch2 or

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

[PERFORM] simple left join slows query more than expected

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