From: | "Len Morgan" <len-morgan(at)crcom(dot)net> |
---|---|
To: | "Linh Luong" <lluong(at)home(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Postgres performance issue |
Date: | 2001-05-28 15:04:58 |
Message-ID: | 003801c0e787$9db59c20$0908a8c0@H233.bstx.cc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>select * from customer where upper(name) like upper('$criteria%')
>
>Does anyone know what the limitation on Postgres? Like how many records
>before it starts to seize and choke on the performance side?
I don't think it's choking on the server side. How many records would you
expect to get back if you select ALL records? If there are a lot of them,
you may be running out of memory on your client (PHP in this case) or it's
allocating space for each record as it comes in which may be what's causing
your performance hit. Also, if you can determine that ALL records are being
requested, it would be faster to remove the LIKE clause since this requires
the server to examine each record whereas just a SELECT * from customer
doesn't.
len morgan
From | Date | Subject | |
---|---|---|---|
Next Message | Len Morgan | 2001-05-28 15:08:57 | Re: problem with buffer in psql |
Previous Message | Marek Pętlicki | 2001-05-28 14:45:35 | Re: transactions on Postgresql |