stgres for windows?
Thanks for your help,
Regards,
Regards,
Russell Keane
[Schnabel, Robert D.]
Have a look at this post. While not directly answering your question as to
fundamental differences it is applicable if you think you're going to be able
to do larger sorts etc.
http://www
Hi,
I'm trying to figure out how to count the number of rows within a fixed range
of the current row value. My table looks like this:
SELECT chr_pos
FROM mutations_crosstab_9615_99
WHERE bta = 38
LIMIT 10
chr_pos
138
140
163
174
187
187
188
208
210
213
chr_pos is integer and represents the ba
:27 AM, Schnabel, Robert D. wrote:
>> I'm trying to figure out how to count the number of rows within a
>> fixed range of the current row value. My table looks like this:
>>
>> SELECT chr_pos
>> FROM mutations_crosstab_9615_99
>> WHERE bta = 38
>>
Hi,
I'm looking for some general info on the behavior of CLUSTER. I add large
amounts of data to an existing table something like this:
BEGIN;
DROP INDEX IF EXISTS xgen1011_si_sn;
COMMIT;
BEGIN;
INSERT INTO gen1011
[snip]
COMMIT;
BEGIN;
CREATE INDEX xgen1011_si_sn
ON gen1011
USING btree
-Original Message-
From: Jeff Janes [mailto:jeff.ja...@gmail.com]
Sent: Thursday, November 29, 2012 11:19 AM
To: Schnabel, Robert D.
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] When does CLUSTER occur?
On Thu, Nov 29, 2012 at 8:11 AM, Schnabel, Robert D.
wrote:
>