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 <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
