On Fri, 2005-10-21 at 10:20 -0400, Tom Lane wrote:
> Mario Splivalo <[EMAIL PROTECTED]> writes:
> > I have a query that does COUNT, LEFT JOIN and GROUP BY from two tables.
> > One has 85000 records, and other has 100 records. I've been running
> > the tests on 7.4.3,
>
> Your later message sho
Mario Splivalo <[EMAIL PROTECTED]> writes:
> I have a query that does COUNT, LEFT JOIN and GROUP BY from two tables.
> One has 85000 records, and other has 100 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
On Friday 21 October 2005 14:34, Mario Splivalo wrote:
| On Fri, 2005-10-21 at 14:01 +0200, Havasvölgyi Ottó wrote:
| > Mike,
| >
| > Please send the EXPLAIN ANALYZE of the two versions of the query.
^^^
| There they are, they are both the same:
|
| join_test=# sele
On Fri, 2005-10-21 at 14:01 +0200, Havasvölgyi Ottó wrote:
> Mike,
>
> Please send the EXPLAIN ANALYZE of the two versions of the query.
There they are, they are both the same:
join_test=# select version();
version
--
Mike,
Please send the EXPLAIN ANALYZE of the two versions of the query.
Best Regards,
Otto
- Original Message -
From: "Mario Splivalo" <[EMAIL PROTECTED]>
To:
Sent: Friday, October 21, 2005 1:13 PM
Subject: [SQL] Postgres 7.4.9 slow!
Hello! I'm not sure if
Hello! I'm not sure if this belongs to this mailing list, if not, please
tell me to redirect to where it belongs.
I have a query that does COUNT, LEFT JOIN and GROUP BY from two tables.
One has 85000 records, and other has 100 records. I've been running
the tests on 7.4.3, with SET ENABLE_SEQS
