Re: [PERFORM] CPU load spikes when CentOS tries to reclaim 'cached' memory

2014-06-05 Thread Deron
what is going on, I would like to know (especially if it is virtualized). Deron On Thu, Jun 5, 2014 at 12:23 PM, Merlin Moncure wrote: > On Thu, Jun 5, 2014 at 10:58 AM, Jeff Janes wrote: > > This sounds like a kernel problem, probably either the zone reclaim > issue, > >

Re: [PERFORM] "Select * " on 12-18M row table from remote machine thru JDBC - Performance nose-dives after 10M-ish records

2012-09-28 Thread Deron
. Determine if it is I/O, CPU, or network. Put all your settings back to the way they were. If the DB did not change, then look at OS and network. Deron On Sep 28, 2012 6:53 AM, "antthelimey" wrote: > On machine 1 - a table that contains between 12 and 18 million rows > On machine 2 -

Re: [PERFORM] database slowdown while a lot of inserts occur

2012-03-29 Thread Deron
ot; to do the bulk insert http://www.postgresql.org/docs/9.0/static/sql-copy.html (or) Drop the indexes (or triggers), do the inserts and build indexes and triggers. Some Hardware suggestions are dependendent on if it is I/O, CPU, or memory bottleneck. Deron On Thu, Mar 29, 2012 at 11:5

Re: [PERFORM] Postgress is taking lot of CPU on our embedded hardware.

2012-01-28 Thread Deron
sible that a specific index creation does not work efficiently on that architecture... http://www.postgresql.org/docs/9.1/static/sql-createindex.html Deron On Sat, Jan 28, 2012 at 10:21 AM, Jayashankar K B wrote: > Hi, > > I downloaded the source code and cross compiled it into a

Re: [PERFORM] pl/pgsql functions outperforming sql ones?

2012-01-27 Thread Deron
You can use PREPARE... EXECUTE to "cache" the plan (as well as parsing). However, I find it unlikely this will would explain the loss in performance you experienced. Deron On Fri, Jan 27, 2012 at 11:36 AM, Carlo Stonebanks wrote: > Yes, I did test it  - i.e. I ran the functions