From: | Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> |
---|---|
To: | Bo Li_Chongqing University <boli9301(at)163(dot)com> |
Cc: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #16316: The application has lost the database connection: |
Date: | 2020-03-25 20:58:57 |
Message-ID: | 20200325205857.c7doevpvj4y6yy2j@development |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Thu, Mar 26, 2020 at 03:55:11AM +0800, Bo Li_Chongqing University wrote:
>Hi Tomas,
>Thank you very much.
>
>
>When I want to insert into a table, if the size of table is bigger than 100 M or much more, the connection will be lost. I guess that local SQL database is not stronger to process the big data. If I limit the size to 10000, it is ok, instead, the connection will be lost.
>
>
>I used this query in the Pgadmin to insert into a table, if I add limit 100, it works. If remove it, the connection will be lost. I just want to generate an new table in the Pgadmin
>insert into variable_capacity_factor
>SELECT v.generation_plant_id, t.raw_timepoint_id, round(cast(capacity_factor as numeric),7),gen_tech,load_zone_id,to_char(t.timestamp_utc,'YYYYMMDD') as timestamp
>FROM a2020_new_variable_capacity_factors_historical_temp v
>JOIN projection_to_future_timepoint ON(v.raw_timepoint_id = historical_timepoint_id)
>JOIN a2020_new_generation_plant_scenario_member_temp USING(generation_plant_id)
>JOIN sampled_timepoint_temp as t ON(t.raw_timepoint_id = future_timepoint_id)
>JOIN a2020_generation_plant as t1 ON(t1.generation_plant_id = v.generation_plant_id)
>WHERE generation_plant_scenario_id = 10
>AND t.time_sample_id=1
>
That's neat, but it doesn't really tell us anything. Did you check the
server log as I suggested? Are there any errors or interesting messages
in the log?
regards
--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | legrand legrand | 2020-03-25 22:39:03 | Re: pg_stat_statements: rows not updated for CREATE TABLE AS SELECT statements |
Previous Message | Tomas Vondra | 2020-03-25 19:27:04 | Re: BUG #16316: The application has lost the database connection: |