Hi,
Please have a look at the functions also - what are they doing? In Oracle
I have come across a situation where a lot of redo log was generated
because one SQL was updating an entire table, instead of a few selected
records. Since the new data was the same as the old data (for records
which
Greg Smith wrote:
John R Pierce wrote:
I know the database has a lot of write volume overall, and its only
one of several databases running in different zones on the server. I
know nothing about the SAN, I suspect its a EMC Symmetrix of some
sort. Probably a generation or two behind latest.
John R Pierce wrote:
I know the database has a lot of write volume overall, and its only
one of several databases running in different zones on the server. I
know nothing about the SAN, I suspect its a EMC Symmetrix of some
sort. Probably a generation or two behind latest. The operations
p
Greg Smith wrote:
My guess is that there's something wrong with your config such that
writes followed by fsync are taking longer than they should. When I
see "sync=0.640 s" into a SAN where that sync operation should be near
instant, I'd be looking for issues in the ZFS intent log setup, how
John R Pierce wrote:
we're having a similar problem with a very update intensive database
that is part of a 24/7 manufacturing operation (no breathing time
unless there's an unusual line down situtation)
Your problem is actually a bit different.
2010-01-23 01:08:13 MYTLOG: checkpoint complet
Greg Smith wrote:
2010-01-22 12:21:48 JSTLOG: checkpoint complete: wrote 83874 buffers
(16.0%); 0 transaction log file(s) added, 0 removed, 32 recycled;
write=138.040 s, sync=0.000 s, total=138.063 s
2010-01-22 12:23:32 JSTLOG: checkpoint complete: wrote 82856 buffers
(15.8%); 0 transaction l
...@hotmail.com
CC: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Slow Query / Check Point Segments
Alex - wrote:
checkpoint_segments = 32# in logfile segments,
min 1, 16MB each
checkpoint_timeout = 30min # range 30s-1h
These parameters are not
Alex - wrote:
checkpoint_segments = 32# in logfile segments, min 1,
16MB each
checkpoint_timeout = 30min # range 30s-1h
These parameters are not so interesting on their own. The important
thing to check is how often checkpoints are happening, and how much work
e
Oh yeah, what's your swappiness setting (assuming you're running some
flavor of linux:
sysctl -a|grep swapp
should tell you. I set it to something small like 5 or so on db
servers. Default of 60 is fine for an interactive desktop but usually
too high for a server.
--
Sent via pgsql-general ma
On Thu, Jan 21, 2010 at 9:13 PM, Alex - wrote:
> Hi
> i am experience slow queries when i run some functions. I noticed the
> following entries in my server log.
> From this, can anyone tell me if I need to change some config parmeters?
> System has 18GB Memory
> shared_buffers = 4GB
10 matches
Mail list logo
