Postgres Pro
Downloads
Home   >   mailing lists

Re: taking a sparse slice of an array - Mailing list pgsql-novice

From Jean-Yves F. Barbier
Subject Re: taking a sparse slice of an array
Date
Msg-id 20111209093331.48cb9bf2@anubis.defcon1
Whole thread Raw
In response to taking a sparse slice of an array  (Michael Lush <mjlush@gmail.com>)
List pgsql-novice
Tree view 
On Fri, 9 Dec 2011 08:15:17 +0000
Michael Lush <mjlush@gmail.com> wrote:

> time psql test -c "SELECT sample_id, snp_data[40000], snp_data[50000] FROM
> gwas_test" > /dev/null
>
> takes 10 minutes :-(

It seems in your case that not using arrays could lead to better
access time.

--
"I'd love to go out with you, but I'm taking punk totem pole
carving."

pgsql-novice by date:

Previous
From: Michael Lush
Date:
Subject: taking a sparse slice of an array
Next
From: Pandu Poluan
Date:
Subject: SELECT from two tables with different field names?