Re: [PERFORM] Poor performance on simple queries compared to sql server express

2013-08-26 Thread Adam Ma7;ruf
varying 36 YES minorityownedbusinessflag character varying 37 YES data_source text 38 YES psc_cd character varying 39 YES On Mon, Aug 26, 2013 at 9:40 AM, Tomas Vondra wrote: > On 26 Srpen 2013, 15:02, Adam Ma'ruf wrote: > > Sure > > > > I just upgraded to 9.2.4. Th

Re: [PERFORM] Poor performance on simple queries compared to sql server express

2013-08-26 Thread Adam Ma7;ruf
a usual advice for MS Win is setting minimal shared bufferes > - 512MB can be too much there. > > Regards > > Pavel Stehule > > > 2013/8/26 Adam Ma'ruf > >> Hi, >> >> I wasn't whether or not to mail to the novice mailing list of this one. >&

[PERFORM] Poor performance on simple queries compared to sql server express

2013-08-25 Thread Adam Ma7;ruf
Hi, I wasn't whether or not to mail to the novice mailing list of this one. Since this is performance related I'm posting it here, but I am definitely a novice at postgresql - converting from mssql just now. I have a ~2.5gb table with ~5M rows of data. A query that groups by two fields and sums