| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | Hervé Piedvache <footcow(at)noos(dot)fr>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: TSearch2 and optimisation ... |
| Date: | 2004-08-25 23:50:53 |
| Message-ID: | 200408251650.53233.josh@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Herve'
> The request takes about 4 seconds ... I have about 1 400 000 records in
> article and 36 000 records in site table ... it's a Bi-Pentium III 933 MHz
> server with 1 Gb memory ... I'm using Postgresql 7.4.5
> For me this result is very very slow I really need a quicker result with
> less than 1 second ...
> The next time I call the same request I have got the result in 439 ms ...
> but If I replace "Postgresql" in my find with "Linux" for example I will
> get the next result in 5 seconds ... :o(
Hmmm. It sounds like your system is unable to keep all of the data cached in
memory. What else do you have going on on that machine?
> Explain gives me this result :
Please do "EXPLAIN ANALYZE" so that we can see where time is actually spent.
--
Josh Berkus
Aglio Database Solutions
San Francisco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2004-08-26 00:38:16 | Re: What is the best way to do attribute/values? |
| Previous Message | Josh Berkus | 2004-08-25 23:49:02 | Re: Anyone familiar with Apple Xserve RAID |