On Sun, Jun 14, 2020 at 10:45:52PM +, Nagaraj Raj wrote:
> My PostgreSQL server 10.11 running on windows which are running very slow. DB
> has two tables with ~200Mil records in each. user queries are very slow even
> explain analyze also taking a longer.
>
> Could you please help me to tune
On Mon, 15 Jun 2020 at 10:46, Nagaraj Raj wrote:
> CREATE TABLE test1
> (
...
> CONSTRAINT pk_i_entity_proxy_id PRIMARY KEY (individual_entity_proxy_id)
>
> );
> CREATE TABLE test2
> (
...
> CONSTRAINT pk_entity_proxy_id PRIMARY KEY (individual_entity_proxy_id)
> );
>
>
> User query:
>
Hello
My PostgreSQL server 10.11 running on windows which are running very slow. DB
has two tables with ~200Mil records in each. user queries are very slow even
explain analyze also taking a longer.
Could you please help me to tune this query and any suggestions to improve
system performanc
