I have a fast P4 Linux server with 2GB mem and yet running a simply SELECT
such as:

select part_number FROM catalog WHERE part_number LIKE 'HH%'

on a catalog table with 14,000 records takes 41.57 seconds.

Can anyone help ... PLEASE ...

Thank you for all the help me,

Sean.

News wrote:
Sean, you should probably post your question in a postgres specific
group (such as pgsql.general). There's a possability that there are no
psql users around here. Anyhow (I'm one of those no psqlers :-), do you
have an index on part_number? If not you are probably doing a table
scan, and that might take some time (41 seconds seems like a lot for
14000 rows though). Also, I seem to remember that there where a vacuum
operation that one should run on a regular basis (that might not be the
case anymore, it was a long time ago I used psql).


/Lennart

"News" <born2net (AT) sbcglobal (DOT) net> wrote:



As Lennart says, go to the Postgres lists.



It looks like that there is no index on "part_number" - is there?



Paul...




--

plinehan __at__ yahoo __dot__ __com__

XP Pro, SP 2,

Oracle, 10.2.0.1 (Express Edition)
Interbase 6.0.2.0;

When asking database related questions, please give other posters
some clues, like operating system, version of db being used and DDL.
The exact text and/or number of error messages is useful (!= "it didn't work!").
Thanks.

Furthermore, as a courtesy to those who spend
time analysing and attempting to help, please
do not top post.