Re: taking a sparse slice of an array

From: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: taking a sparse slice of an array
Date: 2011-12-09 08:33:31
Message-ID: 20111209093331.48cb9bf2@anubis.defcon1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Fri, 9 Dec 2011 08:15:17 +0000
Michael Lush <mjlush(at)gmail(dot)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."

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Pandu Poluan 2011-12-12 04:39:19 SELECT from two tables with different field names?
Previous Message Michael Lush 2011-12-09 08:15:17 taking a sparse slice of an array