Re: [ADMIN] Postgres Database slow

2005-11-24 Thread Jaime Casanova
always CC list On 11/24/05, Nirmal Kumar <[EMAIL PROTECTED]> wrote: > Hi Jamie > > Thanks for the Reply. > > Memory allocated: 756MB. > We are not finding any problem on the Hardware. > > we tried to explain a normal query of same db load in > two different servers and postgres 7.4.2 seems to take

Re: [ADMIN] Postgres Database slow

2005-11-21 Thread Brad Nicholson
Nirmal Kumar wrote: Hi We are facing a slowness problem in posgres Database. Whenver we query a data it is very very slow.It is running on the IBM ISERIES I5 Server. HARDWARE: IBM Iseries I5 PPC Server OS: SUSE LINUX ENTERPRISE SERVER 9.0 POSTGRESSQL: 7.4.2 WEB SERVER: APACHE2 Using the comm

Re: [ADMIN] Postgres Database slow

2005-11-21 Thread Jeff Frost
What is the explain analyze output of the query which is slow? What does your data look like? What's your postgresql.conf look like? On Mon, 21 Nov 2005, Nirmal Kumar wrote: Hi We are facing a slowness problem in posgres Database. Whenver we query a data it is very very slow.It is running

Re: [ADMIN] Postgres Database slow

2005-11-21 Thread Jim C. Nasby
How about the output from explain analyze on one of the slow queries? On Mon, Nov 21, 2005 at 07:04:29AM -0800, Nirmal Kumar wrote: > Hi > > We are facing a slowness problem in posgres Database. > Whenver we query a data it is very very slow.It is > running on the IBM ISERIES I5 Server. > > HAR

Re: [ADMIN] Postgres Database slow

2005-11-21 Thread Jaime Casanova
On 11/21/05, Nirmal Kumar <[EMAIL PROTECTED]> wrote: > Hi > > We are facing a slowness problem in posgres Database. > Whenver we query a data it is very very slow.It is > running on the IBM ISERIES I5 Server. > > HARDWARE: IBM Iseries I5 PPC Server > OS: SUSE LINUX ENTERPRISE SERVER 9.0 > POSTGRESS