Hi everybody,
suppose you have a large table tab and two (or more) queryes like this:
SELECT count(*),A FROM tab WHERE C GROUP BY A;
SELECT count(*),B FROM tab WHERE C GROUP BY B;
is there any way to get both results in a single query,
eventually through stored procedure?
The retrieved [count(*)
On 10/17/07, Heikki Linnakangas <[EMAIL PROTECTED]> wrote:
> Stefano Dal Pra wrote:
> > suppose you have a large table tab and two (or more) queryes like this:
> >
> > SELECT count(*),A FROM tab WHERE C GROUP BY A;
> > SELECT count(*),B FROM tab WHERE C GROUP BY B
Your first post says vacuum goes worse (slower).
I see that you do not issue the -f option (FULL VACUUM).
I had a similar situation with a server (with frequent update)
performing nightly vacuumdb. After a few many days it went
slower and slower.
The first solution was to add the -f switch.
Note
One year ago a Postgres teacher pointed me there:
http://it.toolbox.com/blogs/database-soup/postgresql-publishes-first-real-benchmark-17470
http://www.spec.org/jAppServer2004/results/res2007q3/jAppServer2004-20070606-00065.html
that would be just like what you're looking for.
Regards,
Stefano
O
