| From: | Jaime Casanova <systemguards(at)gmail(dot)com> |
|---|---|
| To: | Nirmal Kumar <nirmal1980(at)yahoo(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Postgres Database slow |
| Date: | 2005-11-21 16:51:54 |
| Message-ID: | c2d9e70e0511210851m372366b2nf83d81d1ff48d65d@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On 11/21/05, Nirmal Kumar <nirmal1980(at)yahoo(dot)com> 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 command line also it is taking long time to
> query a database.
>
> Any Cluses
>
> Regards
> Nirmal
>
>
>
how many memory do you have?
can you show an explain of some query that is slow?
had you run VACUUM ANALYZE (or ANALYZE at least) recently?
it's all the system that slow or just queries? (maybe it is a problem
of lack of resources)
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2005-11-21 16:59:24 | Re: Server Hardware Configuration |
| Previous Message | Alvaro Herrera | 2005-11-21 16:46:43 | Re: Server Hardware Configuration |