I am attempting to benchmark a number of queries over a 15GB dataset with ~
10mil records. When I run linux time on the query execution (single column
projection), it returns 1 minute, but the \timing command returns only 15
seconds? Can someone explain the difference? 1 minute is consistent with
r
On Tue, Sep 24, 2013 at 6:07 PM, Jeff Janes wrote:
> On Tue, Sep 24, 2013 at 1:13 PM, Daniel Tahara wrote:
>
>> I am attempting to benchmark a number of queries over a 15GB dataset with
>> ~ 10mil records. When I run linux time on the query execution (single
>> column p
On Tue, Sep 24, 2013 at 6:37 PM, Daniel Tahara wrote:
> time echo '\\timing select msg from test' | $PG_ROOT/bin/psql >>
> out.txt
This should be:
time echo '\\timing select msg from test' | $PG_ROOT/bin/psql test >>
out.txt
Sorry for the
