Re: [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

[HACKERS] optimization join on random value

2015-05-03 Thread Anton
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-# DATE_CREATED, soe-# HOUSE_NO_OR_NAME, soe-#