Re: Query runs forever after upgrading to 9.3 - Mailing list pgsql-general
| From | Andrus |
|---|---|
| Subject | Re: Query runs forever after upgrading to 9.3 |
| Date | |
| Msg-id | DA80210B4DB84E09A164FE736FE01142@dell2 Whole thread Raw |
| In response to | Re: Query runs forever after upgrading to 9.3 (bricklen <bricklen@gmail.com>) |
| Responses |
Re: Query runs forever after upgrading to 9.3
|
| List | pgsql-general |
Hi!
>Could you also post the results of the following query?
>SELECT name, current_setting(name), source
>FROM pg_settings
>WHERE source NOT IN ('default', 'override');
>SELECT name, current_setting(name), source
>FROM pg_settings
>WHERE source NOT IN ('default', 'override');
In real server where problem is:
1 DateStyle ISO, DMY session
2 default_text_search_config pg_catalog.simple configuration file
3 extra_float_digits 2 session
4 lc_messages Estonian_Estonia.1257 configuration file
5 lc_monetary Estonian_Estonia.1257 configuration file
6 lc_numeric Estonian_Estonia.1257 configuration file
7 lc_time Estonian_Estonia.1257 configuration file
8 listen_addresses * configuration file
9 log_destination stderr configuration file
10 log_line_prefix %t %u %d configuration file
11 log_lock_waits on configuration file
12 log_min_duration_statement 10s configuration file
13 log_min_error_statement warning configuration file
14 log_temp_files 2000kB configuration file
15 log_timezone Europe/Helsinki configuration file
16 logging_collector on configuration file
17 max_connections 100 configuration file
18 max_stack_depth 2MB environment variable
19 port 5432 configuration file
20 search_path firma1, public session
21 shared_buffers 2400MB configuration file
22 TimeZone Europe/Helsinki configuration file
In development computer from where explain was posted and problem with copy of database also occurs:
"application_name";"pgAdmin III - Query Tool";"client"
"bytea_output";"escape";"session"
"client_encoding";"UNICODE";"session"
"client_min_messages";"notice";"session"
"DateStyle";"ISO, DMY";"session"
"default_text_search_config";"pg_catalog.simple";"configuration file"
"lc_messages";"Estonian_Estonia.1257";"configuration file"
"lc_monetary";"Estonian_Estonia.1257";"configuration file"
"lc_numeric";"Estonian_Estonia.1257";"configuration file"
"lc_time";"Estonian_Estonia.1257";"configuration file"
"listen_addresses";"*";"configuration file"
"log_destination";"stderr";"configuration file"
"log_line_prefix";"%t ";"configuration file"
"log_timezone";"Europe/Helsinki";"configuration file"
"logging_collector";"on";"configuration file"
"max_connections";"100";"configuration file"
"max_stack_depth";"2MB";"environment variable"
"port";"5432";"configuration file"
"shared_buffers";"128MB";"configuration file"
"TimeZone";"Europe/Helsinki";"configuration file"
> Also, what is the total memory in the server?
In devel computer where tests are performed, 4 GB
Real server has 16 GB RAM
Real server is for Postgres for this database and ASP.NET MVC3 application which uses this same database from postgres.
Can settings in real server changed to increase perfomance ?
Andrus.
pgsql-general by date: