Re: [GENERAL] [HACKERS] optimization join on random value

2015-05-04 Thread Anton
Yahooo ! Many thanks ! soe=# explain EXECUTE test( random()*45000 ); QUERY PLAN - Index Scan using addresses_cust_ix on addresses (cost=0.43..16.48 rows=3 width=84) Inde

Re: [GENERAL] [HACKERS] optimization join on random value

2015-05-04 Thread Martijn van Oosterhout
On Mon, May 04, 2015 at 12:15:54AM +0300, Anton wrote: > Hello guru of postgres, it's possoble to tune query with join on > random string ? > i know that it is not real life example, but i need it for tests. > > soe=# explain > soe-# SELECT ADDRESS_ID, > soe-# CUSTOMER_ID, > soe-#

Re: [GENERAL] [HACKERS] optimization join on random value

2015-05-03 Thread Jim Nasby
On 5/3/15 4:15 PM, Anton wrote: Hello guru of postgres, it's possoble to tune query with join on random string ? i know that it is not real life example, but i need it for tests. Moving to -general, which is the proper list for this. (BCC -hackers) > soe-# WHERE customer_id = trunc( r