On 4/3/13, Eduardo Morras wrote:
> a) Perhaps process are waiting to I/O, do you take zfs snapshots? How often?
> It can limit your i/o performance. Check the output of #zpool iostat 5
>
> b) Is the zpool ok? If one of the disks lags behind the others (because
> hardware errors) reconstructing the
On 4/2/13, John R Pierce wrote:
> On 4/2/2013 3:35 PM, David Noel wrote:
>> The hardware is a Dell PowerEdge 1420, dual Xeon Nocona's, 3.2ghz,
>> 16gb ram. The disks are 4 Kingston HyperX SATA3's attached to a
>> HighPoint RocketRAID 2721 controller, ZFS, RAID10.
> .
>> postgresql.conf, all st
On 4/3/13, Kevin Grittner wrote:
> David Noel wrote:
>> On 4/2/13, Kevin Grittner wrote:
>>> David Noel wrote:
>>>
'select * from pg_stat_activity' shows that the queries are not
waiting, and are in the idle state.
>>>
>>> The process is idle or the process is running the query? If t
On Tue, 2 Apr 2013 18:08:36 -0500
David Noel wrote:
> On 4/2/13, Kevin Grittner wrote:
> > David Noel wrote:
> >
> >> 'select * from pg_stat_activity' shows that the queries are not
> >> waiting, and are in the idle state.
> >
> > The process is idle or the process is running the query? If the
David Noel wrote:
> On 4/2/13, Kevin Grittner wrote:
>> David Noel wrote:
>>
>>> 'select * from pg_stat_activity' shows that the queries are not
>>> waiting, and are in the idle state.
>>
>> The process is idle or the process is running the query? If the
>> latter, what do you mean when you say
On 4/2/13, John R Pierce wrote:
> On 4/2/2013 3:35 PM, David Noel wrote:
>> The hardware is a Dell PowerEdge 1420, dual Xeon Nocona's, 3.2ghz,
>> 16gb ram. The disks are 4 Kingston HyperX SATA3's attached to a
>> HighPoint RocketRAID 2721 controller, ZFS, RAID10.
> .
>> postgresql.conf, all st
On 4/2/13, Kevin Grittner wrote:
> David Noel wrote:
>
>> 'select * from pg_stat_activity' shows that the queries are not
>> waiting, and are in the idle state.
>
> The process is idle or the process is running the query? If the
> latter, what do you mean when you say "the queries ... are in the
On 4/2/13, Ian Lawrence Barwick wrote:
> 2013/4/3 David Noel :
>> I'm running into a strange issue whereby my postgres processes are
>> slowly creeping to 100% CPU utilization. I'm running
>> postgresql-server-9.2.3, FreeBSD 8.3-RELEASE-p6, and using the
>> postgresql-9.2-1002.jdbc4 driver.
>
> (.
On 4/2/2013 3:35 PM, David Noel wrote:
The hardware is a Dell PowerEdge 1420, dual Xeon Nocona's, 3.2ghz,
16gb ram. The disks are 4 Kingston HyperX SATA3's attached to a
HighPoint RocketRAID 2721 controller, ZFS, RAID10.
.
postgresql.conf, all standard/default except for:
max_connections =
David Noel wrote:
> 'select * from pg_stat_activity' shows that the queries are not
> waiting, and are in the idle state.
The process is idle or the process is running the query? If the
latter, what do you mean when you say "the queries ... are in the
idle state"?
--
Kevin Grittner
EnterpriseD
What's strange is that the crawler will run just fine for up to
several hours. At some point though the CPU utilization slowly begins
to creep higher. Eventually everything locks and the program hangs.
'top' shows the processes connected to the queue database at or near
%100, and the program ceases
2013/4/3 David Noel :
> I'm running into a strange issue whereby my postgres processes are
> slowly creeping to 100% CPU utilization. I'm running
> postgresql-server-9.2.3, FreeBSD 8.3-RELEASE-p6, and using the
> postgresql-9.2-1002.jdbc4 driver.
(...)
> postgresql.conf, all standard/default excep
I'm running into a strange issue whereby my postgres processes are
slowly creeping to 100% CPU utilization. I'm running
postgresql-server-9.2.3, FreeBSD 8.3-RELEASE-p6, and using the
postgresql-9.2-1002.jdbc4 driver.
I'm not sure what information here is relevant, so I'll give
everything I can as
13 matches
Mail list logo
