Re: [PERFORM] 3-table query optimization

2006-08-15 Thread Jim C. Nasby
On Thu, Aug 10, 2006 at 09:30:35AM +0200, Michal Taborsky - Internet Mall wrote: > Tom Lane napsal(a): > >Michal Taborsky - Internet Mall <[EMAIL PROTECTED]> writes: > >>SELECT product.product_id > >> FROM action > >> JOIN product ON (product.product_id=action.product_id) > >> WHERE action.sho

Re: [PERFORM] 3-table query optimization

2006-08-10 Thread Alvaro Herrera
Michal Taborsky - Internet Mall wrote: > Tom Lane napsal(a): > >Michal Taborsky - Internet Mall <[EMAIL PROTECTED]> writes: > >>SELECT product.product_id > >> FROM action > >> JOIN product ON (product.product_id=action.product_id) > >> WHERE action.shop_group_id=1 > >>AND EXISTS (SELECT 1

Re: [PERFORM] 3-table query optimization

2006-08-10 Thread Michal Taborsky - Internet Mall
Tom Lane napsal(a): Michal Taborsky - Internet Mall <[EMAIL PROTECTED]> writes: SELECT product.product_id FROM action JOIN product ON (product.product_id=action.product_id) WHERE action.shop_group_id=1 AND EXISTS (SELECT 1 FROM catalog.product_program WHERE produc

Re: [PERFORM] 3-table query optimization

2006-08-09 Thread Tom Lane
Michal Taborsky - Internet Mall <[EMAIL PROTECTED]> writes: > SELECT product.product_id >FROM action >JOIN product ON (product.product_id=action.product_id) > WHERE action.shop_group_id=1 > AND EXISTS (SELECT 1 > FROM catalog.product_program > WHERE product_id=prod

[PERFORM] 3-table query optimization

2006-08-09 Thread Michal Taborsky - Internet Mall
Hello everyone. My (simplified) database structure is: a) table product (15 rows) product_id BIGINT PRIMARY KEY title TEXT ... b) table action (5000 rows) action_id BIGINT PRIMARY KEY product_id BIGINT, FK to product shop_group_id INTEGER (there are about 5 groups, distributed about e