| From: | "P(dot)J(dot) \"Josh\" Rovero" <rovero(at)sonalysts(dot)com> |
|---|---|
| To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
| Cc: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Critical performance problems on large databases |
| Date: | 2002-04-11 01:41:47 |
| Message-ID: | 3CB4E9DB.3030006@sonalysts.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I can return result sets of 4K records from a database with 2M records
in tenths of a second. Smaller sets of 100 to 800 records take .02 to
0.1 second. This is on linux, pentium III at 500 MHz, pg 7.2.1.
Finding the right indexes made a *big* difference. Index using
the same criteria you use for select.
--
P. J. "Josh" Rovero Sonalysts, Inc.
Email: rovero(at)sonalysts(dot)com www.sonalysts.com 215 Parkway North
Work: (860)326-3671 or 442-4355 Waterford CT 06385
***********************************************************************
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-04-11 02:10:07 | Re: View INSERTs not returning OID in Postgres 7.2.1 |
| Previous Message | Thomas Lockhart | 2002-04-11 00:59:59 | Re: "Bad date external representation '2002-04-09 |