Hello
It is little bit strange - can you send a info about your PostgreSQL
version, send a query, and table description?
In this case, PostgreSQL should to use a hash aggregate, but from some
strange reason, pg didn't do it.
Second strange issue is speed of external sort - it is less than I can
Hi,
I wasn't whether or not to mail to the novice mailing list of this one.
Since this is performance related I'm posting it here, but I am definitely
a novice at postgresql - converting from mssql just now.
I have a ~2.5gb table with ~5M rows of data. A query that groups by two
fields and sums
