Steve wrote:
Original-Nachricht
Datum: Sat, 11 Sep 2010 11:08:00 -0400
Von: Lew
An: pgsql-sql@postgresql.org
Betreff: Re: [SQL] Question regarding indices
On 09/11/2010 08:29 AM, Steve wrote:
I have a small question about the order of values in a query.
Assume I have a
Original-Nachricht
> Datum: Sat, 11 Sep 2010 11:08:00 -0400
> Von: Lew
> An: pgsql-sql@postgresql.org
> Betreff: Re: [SQL] Question regarding indices
> On 09/11/2010 08:29 AM, Steve wrote:
> > I have a small question about the order of values in a query
On 09/11/2010 08:29 AM, Steve wrote:
I have a small question about the order of values in a query.
Assume I have a table with the following fields:
uid INT,
data BIGINT,
hits INT
And an unique index on (uid, data). I use libpq C API to query
data from the table. The query is something li
"Steve" writes:
>> Von: Tom Lane
>> It's unlikely to make enough difference to be worth the trouble.
>>
> Making a quick sort is ultra easy in C. Anyway... is there a
> difference in the speed of the query with pre-sorted values or not?
> If there is one then I will go and sort the values.
I di
Original-Nachricht
> Datum: Sat, 11 Sep 2010 11:04:16 -0400
> Von: Tom Lane
> An: "Steve"
> CC: pgsql-sql@postgresql.org
> Betreff: Re: [SQL] Question regarding indices
> "Steve" writes:
> > I have a small question about the o
Original-Nachricht
> Datum: Sat, 11 Sep 2010 10:05:18 -0400
> Von: Michael Gould
> An: Steve
> Betreff: Re: [SQL] Question regarding indices
> Steve,
>
Hello Michael,
> If I remember correctly the sort only works on the final result set and so
>
"Steve" writes:
> I have a small question about the order of values in a query. Assume I have a
> table with the following fields:
> uid INT,
> data BIGINT,
> hits INT
> And an unique index on (uid, data). I use libpq C API to query data from the
> table. The query is something like this:
Hello List,
I have a small question about the order of values in a query. Assume I have a
table with the following fields:
uid INT,
data BIGINT,
hits INT
And an unique index on (uid, data). I use libpq C API to query data from the
table. The query is something like this:
SELECT uid,data,h
