Re: GiST indexes and concurrency (tsearch2) - Mailing list pgsql-performance

From Marinos J. Yannikos
Subject Re: GiST indexes and concurrency (tsearch2)
Date
Msg-id 42027622.4080800@geizhals.at
Whole thread Raw
In response to Re: GiST indexes and concurrency (tsearch2)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tom Lane schrieb:
> What's the platform exactly (hardware and OS)?

Hardware: http://www.appro.com/product/server_1142h.asp
- SCSI version, 2 x 146GB 10k rpm disks in software RAID-1
- 32GB RAM

OS: Linux 2.6.10-rc3, x86_64, debian GNU/Linux distribution

- CONFIG_K8_NUMA is currently turned off (no change, but now all CPUs
have ~25% load, previously one was 100% busy and the others idle)

- CONFIG_GART_IOMMU=y (but no change, tried both settings)
[other kernel options didn't seem to be relevant for tweaking at the
moment, mostly they're "safe defaults"]

The PostgreSQL data directory is on an ext2 filesystem.

Regards,
  Marinos
--
Dipl.-Ing. Marinos Yannikos, CEO
Preisvergleich Internet Services AG
Obere Donaustrasse 63, A-1020 Wien
Tel./Fax: (+431) 5811609-52/-55

pgsql-performance by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Planner really hates nested loops
Next
From: Oleg Bartunov
Date:
Subject: Re: GiST indexes and concurrency (tsearch2)