I have a query that runs about 30-50 seconds. The query is a join between 2 tables (customer and address), each table with about 400,000 rows. My customer table has fields like first_name and last_name where the address table has city, state, etc. I'm using "like" in most of the query columns, w
er".party_id = pli.party_id)) Filter: (((state)::text ~~ 'M%'::text) AND ((city)::text ~~ 'AL%'::text))
From: Michael Glaesemann <[EMAIL PROTECTED]>To: Tom Tamulewicz <[EMAIL PROTECTED]>CC: pgsql-performance@postgresql.orgSubject: Re: [PERFORM] Slow j
From: Michael Glaesemann <[EMAIL PROTECTED]>To: Tom Tamulewicz <[EMAIL PROTECTED]>CC: pgsql-performance@postgresql.orgSubject: Re: [PERFORM] Slow join queryDate: Fri, 22 Jun 2007 14:51:32 -0500>>On Jun 22, 2007, at 13:32 , Tom Tamulewicz wrote:>>( p.void_flag IS NUL
