Re: GiST indexes and concurrency (tsearch2)

Поиск
Список
Период
Сортировка
От Marinos J. Yannikos
Тема Re: GiST indexes and concurrency (tsearch2)
Дата
Msg-id 42027622.4080800@geizhals.at
обсуждение исходный текст
Ответ на Re: GiST indexes and concurrency (tsearch2)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Planner really hates nested loops
Следующее
От: Oleg Bartunov
Дата:
Сообщение: Re: GiST indexes and concurrency (tsearch2)