Re: [PERFORM] Question about explain-command...

2006-05-11 Thread Jim C. Nasby
On Wed, May 10, 2006 at 09:47:07AM -0500, Dave Dutcher wrote: > The hash lines mean your tables are being joined by hash joins. You > should read this page for more info: > > http://www.postgresql.org/docs/8.1/interactive/performance-tips.html You might also want to read http://www.pervasivepost

Re: [PERFORM] Question about explain-command...

2006-05-10 Thread Nis Jorgensen
I will try answering your questions. Please note that I am a newbie myself. Clemens Eisserer wrote > All primary keys are indixed, and this is what explain tells me: > Unique (cost=15.67..16.69 rows=34 width=115) > -> Sort (cost=15.67..15.75 rows=34 width=115) > Sort Key: customer.em

Re: [PERFORM] Question about explain-command...

2006-05-10 Thread Dave Dutcher
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Clemens Eisserer > Sent: Wednesday, May 10, 2006 6:50 AM > To: pgsql-performance@postgresql.org > Subject: [PERFORM] Question about explain-command... > > What does the hash-lines mean, does that