table which has records almost 16crore i thought my problem
will solve...
Regards
Hashim
On Tue, Nov 8, 2011 at 5:20 PM, Tomas Vondra wrote:
> On 8 Listopad 2011, 4:21, Mohamed Hashim wrote:
> > Hi all,
> >
> > Thanks for all your responses.
> >
> > Sorry for late
Hi all,
Thanks for all your responses.
Sorry for late response
Earlier we used Postgres8.3.10 with Desktop computer (as server) and
configuration of the system (I2 core with 4GB RAM) and also the application
was slow i dint change any postgres config settings.
May be because of low config We t
Dear All
Thanks for your suggestions & replies.
The below are the sample query which i put for particular one bill_id
EXPLAIN ANALYZE SELECT abd.bill_no as
bill_no,to_char(abd.bill_date,'dd/mm/') AS date,mp.product_desc as
product_desc,std.quantity,std.area,rip.price AS rate
FROM acc_bill_it
Any idea or suggestions how to improve my database best
performance.???
Regards
Hashim
On Sat, Oct 29, 2011 at 9:40 AM, Mohamed Hashim wrote:
> Thanks Alban & Gregg.
>
>
> i will describe little more about that table
>
>
>- We are using PHP appli
rmance??*
Kindly help to sort out this problem..
Thanks in advance..!!
Regards
Hashim
On Fri, Oct 28, 2011 at 5:07 PM, Alban Hertroys wrote:
> On 28 October 2011 09:02, Mohamed Hashim wrote:
> > EXPLAIN
Actually we are using various views and functions to get the info for
reporting purpose in that views or functions we have used or joined the
above table mentioned.
I thought of will get reply from any one from the lists so only i put anyway
i will continue with only pgsql-performance mailing list
I have Quadcore server with 8GB RAM
vendor_id : GenuineIntel
cpu family : 6
model : 44
model name : Intel(R) Xeon(R) CPU E5607 @ 2.27GHz
stepping: 2
cpu MHz : 1197.000
cache size : 8192 KB
MemTotal:8148636 kB
MemFree: 4989
