|
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'); 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. |
