Re: [PERFORM] Having I/O problems in simple virtualized environment

2012-01-31 Thread Jose Ildefonso Camargo Tolosa
On Mon, Jan 30, 2012 at 3:11 AM, Ron Arts ron.a...@gmail.com wrote: Op 30-01-12 02:52, Jose Ildefonso Camargo Tolosa schreef: On Sun, Jan 29, 2012 at 6:18 PM, Ron Arts ron.a...@gmail.com wrote: Hi list, I am running PostgreSQL 8.1 (CentOS 5.7) on a VM on a single XCP (Xenserver) host

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

2012-01-29 Thread Jose Ildefonso Camargo Tolosa
Greetings, On Sat, Jan 28, 2012 at 12:51 PM, Jayashankar K B jayashankar...@lnties.com wrote: Hi, I downloaded the source code and cross compiled it into a relocatable package and copied it to the device. LTIB was the cross-compile tool chain that was used. Controller is  coldfire

Re: [PERFORM] Having I/O problems in simple virtualized environment

2012-01-29 Thread Jose Ildefonso Camargo Tolosa
On Sun, Jan 29, 2012 at 6:18 PM, Ron Arts ron.a...@gmail.com wrote: Hi list, I am running PostgreSQL 8.1 (CentOS 5.7) on a VM on a single XCP (Xenserver) host. This is a HP server with 8GB, Dual Quad Core, and 2 SATA in RAID-1. The problem is: it's running very slow compared to running it

Re: [PERFORM] Large rows number, and large objects

2011-07-21 Thread Jose Ildefonso Camargo Tolosa
On Wed, Jul 20, 2011 at 3:03 PM, Andrzej Nakonieczny dzemik-pgsql-performa...@e-list.pingwin.eu.org wrote: W dniu 20.07.2011 17:57, Jose Ildefonso Camargo Tolosa pisze: [...]    Many of the advantages of partitioning have to do with maintenance    tasks.  For example, if you gather data

Re: [PERFORM] Large rows number, and large objects

2011-07-20 Thread Jose Ildefonso Camargo Tolosa
On Tue, Jul 19, 2011 at 3:57 PM, Robert Haas robertmh...@gmail.com wrote: On Sun, Jun 19, 2011 at 10:19 PM, Jose Ildefonso Camargo Tolosa ildefonso.cama...@gmail.com wrote: So, the question is, if I were to store 8TB worth of data into large objects system, it would actually make

Re: [PERFORM] [GENERAL] DELETE taking too much memory

2011-07-08 Thread Jose Ildefonso Camargo Tolosa
On Fri, Jul 8, 2011 at 4:35 AM, Dean Rasheed dean.a.rash...@gmail.comwrote: On Thu, 2011-07-07 at 15:34 +0200, vincent dephily wrote: Hi, I have a delete query taking 7.2G of ram (and counting) but I do not understant why so much memory is necessary. The server has 12G, and I'm afraid

Re: [PERFORM] Large rows number, and large objects

2011-06-19 Thread Jose Ildefonso Camargo Tolosa
Hi! Thanks (you both, Samuel and Craig) for your answers! On Sun, Jun 19, 2011 at 11:19 AM, Craig James craig_ja...@emolecules.com wrote: On 6/19/11 4:37 AM, Samuel Gendler wrote: On Sat, Jun 18, 2011 at 9:06 PM, Jose Ildefonso Camargo Tolosa ildefonso.cama...@gmail.com wrote: Greetings

[PERFORM] Large rows number, and large objects

2011-06-18 Thread Jose Ildefonso Camargo Tolosa
Greetings, I have been thinking a lot about pgsql performance when it is dealing with tables with lots of rows on one table (several millions, maybe thousands of millions). Say, the Large Object use case: one table has large objects (have a pointer to one object). The large object table stores

Re: [PERFORM] Performance on new 64bit server compared to my 32bit desktop

2010-08-31 Thread Jose Ildefonso Camargo Tolosa
Hi! On Tue, Aug 31, 2010 at 8:11 AM, Yeb Havinga yebhavi...@gmail.com wrote: Greg Smith wrote: Yeb Havinga wrote: model name      : AMD Phenom(tm) II X4 940 Processor @ 3.00GHz cpu cores         : 4 stream compiled with -O3 Function      Rate (MB/s)   Avg time     Min time     Max time

Re: [PERFORM] Performance on new 64bit server compared to my 32bit desktop

2010-08-31 Thread Jose Ildefonso Camargo Tolosa
Hi! On Tue, Aug 31, 2010 at 11:13 AM, Greg Smith g...@2ndquadrant.com wrote: Yeb Havinga wrote: The rather wierd dip at 5 threads is consistent over multiple tries I've seen that twice on 4 core systems now.  The spot where there's just one more thread than cores seems to be the worst case

Re: [PERFORM] Performance on new 64bit server compared to my 32bit desktop

2010-08-30 Thread Jose Ildefonso Camargo Tolosa
Hi! Thanks you all for this great amount of information! What memory/motherboard (ie, chipset) is installed on the phenom ii one? it looks like it peaks to ~6.2GB/s with 4 threads. Also, what kernel is on it? (uname -a would be nice). Now, this looks like sustained memory speed, what about

Re: [PERFORM] Performance on new 64bit server compared to my 32bit desktop

2010-08-30 Thread Jose Ildefonso Camargo Tolosa
Hi! Thanks for the review link! Ildefonso. On Mon, Aug 30, 2010 at 6:01 PM, Greg Smith g...@2ndquadrant.com wrote: Clemens Eisserer wrote: Hi, This isn't an older Opteron, its 6 core, 6MB L3 cache Istanbul.  Its not the newer stuff either. Everything before Magny Cours is now an