Is
SELECT DISTINCT foo, bar FROM baz;
equivalent to
SELECT foo, bar from baz GROUP BY foo, bar;
?
In the former case, pgsql >= 7.4 does not use HashAgg, but uses it for
the latter case. In many circumstances, esp. for large amount of data
in the table baz, the second case is an order of a mag
I'm hoping I'll have the opportunity to build a similar machine soon and am
wondering about the choice of 64 bit distributions.
Gentoo is obviously a possibility but I'm also condsidering Debian. There is
also a 64 compile of redhat sources somewhere around, but I can't remember
what they call
Matt - Very interesting information about squid effectiveness, thanks.
Martin,
You mean your site had no images? No CSS files? No JavaScript files? Nearly
everything is dynamic?
I've found that our CMS spends more time sending a 23KB image to a dial up
user than it does generating and serving dyn
On Sat, 06 Nov 2004 11:52:15 -0800, Carlos Lopez wrote:
> I have migrated a database from MS SQL to a
> postgresSQL database, but when running it, the results
> are very slow (and unusable) which is the only reason
> we don't entirely move to postgresSQL.
Have you run ANALYZE lately? (See manual.
Hi Andrew,
I had never heard of Ubuntu before, thanks for the tip.
regards
iain
- Original Message -
From: "Andrew McMillan" <[EMAIL PROTECTED]>
To: "Iain" <[EMAIL PROTECTED]>
Sent: Monday, November 08, 2004 12:51 PM
Subject: Re: [PERFORM] postgresql amd-64
