On 03/28/2011 04:21 PM, Greg Smith wrote:
Today is the launch of Intel's 3rd generation SSD line, the 320
series. And they've finally produced a cheap consumer product that
may be useful for databases, too! They've put 6 small capacitors onto
the board and added logic to flush the write cache
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.
Lars Feistner wrote:
> On 03/30/2011 06:54 PM, Kevin Grittner wrote:
>> If you haven't already done so, you should probably turn on
>> checkpoint logging to see if this corresponds to checkpoint
>> activity. If it does, you can try cranking up how aggressive
>> your background writer is, and pe
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,
On 03/30/2011 06:54 PM, Kevin Grittner wrote:
Lars Feistner wrote:
On 03/29/2011 09:28 PM, Kevin Grittner wrote:
Lars Feistner wrote:
The log tells me that certain update statements take sometimes
about 3-10 minutes. But we are talking about updates on tables
with 1000 to 1 rows and
19 matches
Mail list logo
