On Mon, Jul 23, 2012 at 11:03 AM, Daniele Varrazzo
> 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.
In response to
pgsql-performance by date
|Next:||From: Andrew Dunstan||Date: 2012-07-23 12:29:16|
|Subject: Re: Checkpointer split has broken things dramatically (was
Re: DELETE vs TRUNCATE explanation)|
|Previous:||From: Daniele Varrazzo||Date: 2012-07-23 10:03:11|
|Subject: Shards + hash = forever running queries|