On Apr 5, 2011, at 9:33 AM, Adarsh Sharma wrote:
> Now I have to start more queries on Database Server and issue new connections
> after some time. Why the cached memory is not freed.
It's freed on-demand.
> Flushing the cache memory is needed & how it could use so much if I set
Why would forc
On Tue, Apr 5, 2011 at 7:20 AM, Adarsh Sharma wrote:
> Scott Marlowe wrote:
>
> On Tue, Apr 5, 2011 at 1:33 AM, Adarsh Sharma
> wrote:
>
>
> [root@s8-mysd-2 ~]# free -m
> total used free shared buffers cached
> Mem: 15917 15826 90 0
Scott Marlowe wrote:
On Tue, Apr 5, 2011 at 1:33 AM, Adarsh Sharma wrote:
[root@s8-mysd-2 ~]# free -m
total used free sharedbuffers cached
Mem: 15917 15826 90 0101 15013
-/+ buffers/cache:711 15205
Swa
On Tue, Apr 5, 2011 at 1:33 AM, Adarsh Sharma wrote:
>
> [root@s8-mysd-2 ~]# free -m
> total used free shared buffers cached
> Mem: 15917 15826 90 0 101 15013
> -/+ buffers/cache: 711 15205
> Swap: 16394
On Apr 5, 2011, at 9:33 AM, Adarsh Sharma wrote:
> Now I have to start more queries on Database Server and issue new connections
> after some time. Why the cached memory is not freed.
It's freed on-demand.
> Flushing the cache memory is needed & how it could use so much if I set
Why would forc
Hi, Good Morning To All of You.
Yesterday I had some research on my problems. As Scott rightly suggest
me to have pre information before posting in the list, I aggreed to him.
Here is my first doubt , that I explain as:
My application makes several connections to Database Server & done their
Best of luck, the two standard links for this kind of problem are:
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
http://wiki.postgresql.org/wiki/SlowQueryQuestions
Note that in creating the information needed to report a problem you
may well wind up troubleshooting it and fixing it.
Adarsh,
> [root@s8-mysd-2 8.4SS]# iostat
> -bash: iostat: command not found
>
> /usr/bin/iostat
Our application runs by making connections to Postgres Server from different
> servers and selecting data from one table & insert into remaining tables in
> a database.
When you are doing bulk inser
Thank U all,
I know some things to work on & after some work & study on them , I will
continue this discussion tomorrow .
Best Regards,
Adarsh
Raghavendra wrote:
Adarsh,
[root@s8-mysd-2 8.4SS]# iostat
-bash: iostat: command not found
/usr/bin/iostat
Our application runs
>
>
> Thanks Scott :
>
> My iostat package is not installed but have a look on below output:
>
> [root@s8-mysd-2 8.4SS]# vmstat 10
> procs ---memory-- ---swap-- -io --system--
> -cpu--
> r b swpd free buff cache si sobibo incs us sy
> id wa
On Mon, Apr 4, 2011 at 5:51 AM, Adarsh Sharma wrote:
>
>
> Thanks Scott :
>
> My iostat package is not installed but have a look on below output:
>
> [root@s8-mysd-2 8.4SS]# vmstat 10
> procs ---memory-- ---swap-- -io --system--
> -cpu--
> r b swpd free buff
You got to have something to compare against.
I would say, try to run some benchmarks (pgbench from contrib) and compare them
against a known good instance of postgresql, if you have access in such a
machine.
That said, and forgive me if i sound a little "explicit" but if you dont know
how to in
Thanks Scott :
My iostat package is not installed but have a look on below output:
[root@s8-mysd-2 8.4SS]# vmstat 10
procs ---memory-- ---swap-- -io --system--
-cpu--
r b swpd free buff cache si sobibo incs us sy
id wa st
1 0 147664
On Mon, Apr 4, 2011 at 5:34 AM, Adarsh Sharma wrote:
> Mem: 16299476k total, 16198784k used, 100692k free, 73776k buffers
> Swap: 16787884k total, 148176k used, 16639708k free, 15585396k cached
>
> PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+
> COMMAND
> 3401 postgres 20
My database size is :-
postgres=# select pg_size_pretty(pg_database_size('pdc_uima_dummy'));
pg_size_pretty
49 GB
(1 row)
I have a doubt regarding postgres Memory Usage :-
Say my Application makes Connection to Database Server ( *.*.*.106) from
(*.*.*.111, *.*.*.113, *.*.*.114)
Adarsh,
What is the Size of Database?
Best Regards,
Raghavendra
EnterpriseDB Corporation
On Mon, Apr 4, 2011 at 4:24 PM, Scott Marlowe wrote:
> On Mon, Apr 4, 2011 at 4:43 AM, Scott Marlowe
> wrote:
> >
> >> [root@s8-mysd-2 ~]# free total used free
> shared
> >>buf
On Mon, Apr 4, 2011 at 4:43 AM, Scott Marlowe wrote:
>
>> [root@s8-mysd-2 ~]# free total used free shared
>> buffers cached
>> Mem: 16299476 16202264 97212 0 58924 15231852
>> -/+ buffers/cache: 911488 15387988
>> Swap: 1678
Also you can try to take the help of pgtune before hand.
pgfoundry.org/projects/*pgtune*/
On Mon, Apr 4, 2011 at 12:43 PM, Scott Marlowe wrote:
> On Mon, Apr 4, 2011 at 3:40 AM, Adarsh Sharma
> wrote:
> > Dear all,
> >
> > I have a Postgres database server with 16GB RAM.
> > Our application ru
On Mon, Apr 4, 2011 at 3:40 AM, Adarsh Sharma wrote:
> Dear all,
>
> I have a Postgres database server with 16GB RAM.
> Our application runs by making connections to Postgres Server from different
> servers and selecting data from one table & insert into remaining tables in
> a database.
>
> Below
t...@fuzzy.cz wrote:
max_connections = 700
shared_buffers = 4096MB
temp_buffers = 16MB
work_mem = 64MB
maintenance_work_mem = 128MB
wal_buffers = 32MB
checkpoint_segments = 32
random_page_cost = 2.0
effective_cache_size = 4096MB
First of all, there's no reason to increase wal_buffers above 32MB
> max_connections = 700
> shared_buffers = 4096MB
> temp_buffers = 16MB
> work_mem = 64MB
> maintenance_work_mem = 128MB
> wal_buffers = 32MB
> checkpoint_segments = 32
> random_page_cost = 2.0
> effective_cache_size = 4096MB
First of all, there's no reason to increase wal_buffers above 32MB. AFAI
Dear all,
I have a Postgres database server with 16GB RAM.
Our application runs by making connections to Postgres Server from
different servers and selecting data from one table & insert into
remaining tables in a database.
Below is the no. of connections output :-
postgres=# select datname,
22 matches
Mail list logo
