Re: [PERFORM] Why do my hash joins turn to nested loops?

s good timing. Thanks! -- Ian Smith www.ian.org -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

[PERFORM] Why do my hash joins turn to nested loops?

09 width=8) (actual time=0.009..7.996 rows=8172 loops=3555) Filter: (specs_sort.spec_uid = 4) -> Index Scan using type_pkey on type (cost=0.00..0.27 rows=1 width=4) (actual time=0.010..0.011 rows=1 loops=3555) Index Cond: ((logical.typ

Re: [PERFORM] tsearch2 headline and postgresql.conf

Oleg Bartunov wrote: You didn't provides us any query with explain analyze. Just to make sure you're fine. Oleg On Sun, 22 Jan 2006, [EMAIL PROTECTED] wrote: Hi folks, I'm not sure if this is the right place for this but thought I'd ask. I'm relateively new to postgres having only used

[PERFORM] tsearch2 headline and postgresql.conf

Hi folks, I'm not sure if this is the right place for this but thought I'd ask. I'm relateively new to postgres having only used it on 3 projects and am just delving into the setup and admin for the second time. I decided to try tsearch2 for this project's search requirements but am having

Re: [PERFORM] Sun performance - Major discovery!

In message <[EMAIL PROTECTED]>, Jeff writes: I'll go run the regression test suite with my gcc -O2 pg and the suncc pg. See if they pass the test. My default set of gcc optimization flags is: -O3 -funroll-loops -frerun-cse-after-loop -frerun-loop-opt -falign-functions -mcpu=i686 -march