Re: Shards + hash = forever running queries

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Jul 23, 2012 at 11:03 AM, Daniele Varrazzo
<daniele.varrazzo@xxxxxxxxx> wrote:

> 1. Can we fix the queries to work around this problem?

As a stop-gap measure I've defined a get_big(id) function and using it
to pull in the details we're interested into from the "big" table:

    create function get_big (id int) returns big as $$
    select * from big where id = $1;
    $$ language sql stable strict;

I'm not completely satisfied by it though: if there's any better
solution I'd be happy to know.

Thank you,

-- Daniele

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux