| From: | Markus Schaber <schabi(at)logix-tt(dot)com> |
|---|---|
| To: | Jeremiah Jahn <jeremiah(at)cs(dot)earlham(dot)edu> |
| Cc: | Dave Held <dave(dot)held(at)arrayservicesgrp(dot)com>, John A Meinel <john(at)arbash-meinel(dot)com>, postgres performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: name search query speed |
| Date: | 2005-03-03 22:03:44 |
| Message-ID: | 422789C0.20201@logix-tt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi, Jeremiah,
Jeremiah Jahn schrieb:
> doesn't that cause two queries? I used to do it that way and cut my time
> substantially by counting in-line. Even though the results were cached
> it still took more time.
This sounds rather strange.
> Also since the tables is constantly be updated
> the returned total would not always match the number of results on the
> second query.
Did you run both queries in the same transaction, with transaction
isolation level set to serializable? If yes, you found a serious bug in
PostgreSQL transaction engine.
Markus
--
Markus Schaber | Dipl. Informatiker | Software Development GIS
Fight against software patents in EU! http://ffii.org/
http://nosoftwarepatents.org/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ken Egervari | 2005-03-03 23:42:46 | Re: Help with tuning this query (with explain analyze finally) |
| Previous Message | John Arbash Meinel | 2005-03-03 21:37:21 | Re: name search query speed |