Re: [GENERAL] 64 bit Win 2008, 32 bit client, ?bit Postgres?

2013-02-07 Thread Schnabel, Robert D.
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

[GENERAL] window function help

2014-04-03 Thread Schnabel, Robert D.
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

Re: [GENERAL] window function help

2014-04-03 Thread Schnabel, Robert D.
: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 >>

[GENERAL] When does CLUSTER occur?

2012-11-29 Thread Schnabel, Robert D.
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

Re: [GENERAL] When does CLUSTER occur?

2012-11-29 Thread Schnabel, Robert D.
-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: >