Re: Slow Performance in PostgreSQL - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: Slow Performance in PostgreSQL
Date
Msg-id 3B5FA07E.62EB4FBC@fourpalms.org
Whole thread Raw
In response to Re: Slow Performance in PostgreSQL  (Hiroshi Inoue <Inoue@tpf.co.jp>)
List pgsql-hackers
> How many rows are returned by the query in reality ?
> Does the table *table1* have an index on the column *var1*
> in your centura sqlbase ?

... and did you do a "vacuum analyze"? What is the schema? What is the
query? What is the result of "explain" for that query?

All of these things are relevant for any inquiry regarding poor
performance. I'm sure you will get acceptable performance once things
are adjusted.
                  - Thomas


pgsql-hackers by date:

Previous
From: "Steve Howe"
Date:
Subject: LIBPQ on Windows and large Queries
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Bug in ADD COLUMN with REFERENCES