| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | mario(dot)splivalo(at)mobart(dot)hr |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Postgres 7.4.9 slow! |
| Date: | 2005-10-21 14:20:07 |
| Message-ID: | 21209.1129904407@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Mario Splivalo <mario(dot)splivalo(at)mobart(dot)hr> writes:
> I have a query that does COUNT, LEFT JOIN and GROUP BY from two tables.
> One has 85000 records, and other has 1000000 records. I've been running
> the tests on 7.4.3,
Your later message shows 7.4.8. Which is it?
> But, now I downloaded postgres 7.4.9, and i'm running the very same
> query on the very same database with all the indices and constraints
> beeing the same (also SET ENABLE_SEQSCAN TO OFF), and I get around
> 90-110 seconds.
You sure it's the very same? The version outputs suggest that these
might be two different machines; certainly two very different compilers
were used. One thing I'd wonder about is whether both databases were
initialized in the same locale.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mario Splivalo | 2005-10-21 14:32:30 | Re: Postgres 7.4.9 slow! |
| Previous Message | gurkan | 2005-10-21 14:19:51 | SQL Functions |