Re: Query Speed!!!

--- Hans-Juergen Schoenig <hs(at)cybertec(dot)at> wrote:
> Thirumoorthy Bhuvneswari wrote:
> > hi,
> > I am using Postgresql-7.1.3 with RedHat Linux-7.1 and
> > JDBC. I am having an indexed table with nearly 3,000
> > records for a month. My machine is with 256 MB RAM,
> > 600 MHz. I am having a report from the abovesaid
> > table, which displays 1 month's records at a stretch
> > using Swing components. If I run the query from the
> > hard-disk
> > it takes about 5 seconds to display all the 3,000
> > records. If I connect 3 nodes to it and run the query
> > from a node, it takes about 1.5 minutes. I don't know
> > where I am wrong. Please do reply. thanks.

Please tell us two more things:

1) If you enter the query by hand at the psql prompt how
long does the query take?

2) What is the SQL query? Show us the SQL you entered.

I would expect much beter 10x to 100x speeds for most "normal"
queries. But do the above _after_ a "vacuum full analyze"

=====
Chris Albertson
Home: 310-376-1029 chrisalbertson90278(at)yahoo(dot)com
Cell: 310-990-7550
Office: 310-336-5189 Christopher(dot)J(dot)Albertson(at)aero(dot)org

__________________________________________________
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com