Skip site navigation (1) Skip section navigation (2)

Re: is it possible to make this faster?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
Cc: "Postgresql Performance" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: is it possible to make this faster?
Date: 2006-05-26 17:55:15
Message-ID: 27570.1148666115@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
"Merlin Moncure" <mmoncure(at)gmail(dot)com> writes:
> can't thing of anything, I'm running completely stock, did you do a
> optimize table foo?

Nope, never heard of that before.  But I did it, and it doesn't seem to
have changed my results at all.

> mysql> select user_id, acc_id, max(sample_date) from usage_samples group by 1,2
> 939 rows in set (0.07 sec)

0.07 seconds is not impossibly out of line with my result of 0.15 sec,
maybe your machine is just 2X faster than mine.  This is a 2.8GHz dual
Xeon EM64T, what are you testing?  You said "less than 20 msec" before,
what was that on?

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Worky WorkersonDate: 2006-05-26 18:48:20
Subject: Bulk loading/merging
Previous:From: Merlin MoncureDate: 2006-05-26 17:46:30
Subject: Re: is it possible to make this faster?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group