Re: Postgresql TPS Bottleneck

2022-04-20 Thread Benedict Holland
Ypu wouldn't get an increasing running two instances on the same server. Distributed database severs is a complex application and tuning it will depend on storage and CPU capacity. It could be as simple as a bus. Are you running this locally or on the cloud? Are you running this on a distributed fi

Re: constraint exclusion with ineq condition (Re: server hardware tuning.)

2019-02-15 Thread Benedict Holland
Hi Sugathi, That sounds like a perfect task for a view if the joins are all the same. ~Ben On Fri, Feb 15, 2019 at 9:36 AM suganthi Sekar wrote: > Hi, > > > yes i accept , but when i will do for existing tables, i am facing issue. > > > > I have created 100 Function , all the function having

Re: Postgres views cannot use both union and join/where

2021-10-19 Thread Benedict Holland
I thought a union mashed together two queries. The where clause can appear in both. But the execution plan will almost certainly run the first query and the second query. It should throw an error if the types don't match or the number of columns don't match. There are so few use cases for unions t