Re: Poor performance on seq scan
От
Ivan Voras
Тема
Re: Poor performance on seq scan
Дата
Msg-id
450871C9.1010709@fer.hr
Список
Дерево обсуждения
Poor performance on seq scan Laszlo Nagy <gandalf@designaproduct.biz>
Re: Poor performance on seq scan Tom Lane <tgl@sss.pgh.pa.us>
Re: Poor performance on seq scan Laszlo Nagy <gandalf@designaproduct.biz>
Re: Poor performance on seq scan Tom Lane <tgl@sss.pgh.pa.us>
Re: Poor performance on seq scan "Craig A. James" <cjames@modgraph-usa.com>
Re: Poor performance on seq scan Laszlo Nagy <gandalf@designaproduct.biz>
Re: Poor performance on seq scan Mark Kirkwood <markir@paradise.net.nz>
Re: Poor performance on seq scan "Luke Lonergan" <llonergan@greenplum.com>
Re: Poor performance on seq scan Laszlo Nagy <gandalf@designaproduct.biz>
Re: Poor performance on seq scan Dave Cramer <pg@fastcrypt.com>
Re: Poor performance on seq scan "Luke Lonergan" <llonergan@greenplum.com>
Re: Poor performance on seq scan Heikki Linnakangas <heikki@enterprisedb.com>
Re: Poor performance on seq scan Piotr Kołaczkowski <P.Kolaczkowski@elka.pw.edu.pl>
Re: Poor performance on seq scan Markus Schaber <schabi@logix-tt.com>
Re: Poor performance on seq scan "Guido Neitzer" <guido.neitzer@gmail.com>
Re: Poor performance on seq scan Laszlo Nagy <gandalf@designaproduct.biz>
Re: Poor performance on seq scan Guillaume Cottenceau <gc@mnc.ch>
Re: Poor performance on seq scan Heikki Linnakangas <heikki@enterprisedb.com>
Re: Poor performance on seq scan Alvaro Herrera <alvherre@commandprompt.com>
Re: Poor performance on seq scan Tom Lane <tgl@sss.pgh.pa.us>
tsearch2 question (was: Poor performance on seq scan) Laszlo Nagy <gandalf@designaproduct.biz>
Re: tsearch2 question (was: Poor performance on seq "Luke Lonergan" <llonergan@greenplum.com>
Re: Poor performance on seq scan Heikki Linnakangas <heikki@enterprisedb.com>
pgsql-performance-owner@postgresql.org wrote: > This board has Intel chipset. I cannot remember the exact type but it > was not in the low end category. > dmesg says: > > > kernel: ad4: 152626MB at ata2-master SATA150 > kernel: ad4: 152627MB at ata3-master SATA150 There have been reported problems with ICH7 on FreeBSD mailing lists, though I can't find any that affect performance. > Components: 2 > Balance: round-robin > Slice: 4096 See if changing balance algorithm to "split", and slice size to 8192 or more, while keeping vfs.read_max to 16 or more helps your performance. (e.g. gmirror configure -b split -s 8192 gm0) Also, how is your file system mounted? (what does output from 'mount' say?)
В списке pgsql-performance по дате отправления
