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 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
>
>
>
>
> __________________________________
> Yahoo! FareChase: Search multiple travel sites in one click.
> http://farechase.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
>
--
Jeff Frost, Owner <jeff@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954