hi folks,
we are looking for a PostgreSQL DBA to help us in tuning our database.
Could you please recommend somebody in your network?
thanks,
--daya--
>
>
>
> As none of the columns of the joined table are used, most probably
> this should be re-written as an EXISTS condition.
> Then neither GROUP BY nor DISTINCT is needed.
>
>
I need the columns from joined tables. To keep it simple, I didn't include
them in the query. EXISTS solution won't work
Yes. I can tweak the query. Version of postgres is 9.5.15. I have about 20
partitions for company_sale_account table.
I do have an index on company name.
I need to use DISTINCT as i need to remove the duplicates.
Thanks for your time.
On Sun, Mar 22, 2020 at 11:38 PM Michael Lewis wrote:
> A
Hi folks,
We are using postgreSQL database and I am hitting some limits. I have
partitions on company_sale_account table
based on company name
We generate a report on accounts matched between the two. Below is the
query:
SELECT DISTINCT cpsa1.*
FROM company_sale_account cpsa1
JOIN company_sale
