these arrays a part of [s] would make these queries
slower. Or would be better to store the array data in a separate table
e.g. have [s] as it is now but turn [sp] into an array aggregated table.
Thanks,
Lutz
On 15/06/17 15:37, Stephen Frost wrote:
Greetings,
* Lutz Fischer (l.fisc...@ed.
Hi,
I have two tables
s {
id bigint NOT NULL PRIMARY KEY,
...
}
sp {
id bigint PRIMARY KEY,
sid bigint REFERENCES s (id),
i numeric,
m numeric
...
}
I have for each entry in [s] on average around 120 entries in [sp]. And
that table has become the largest table in my
) - but at least I have a
solution I can work with.
On 13/12/12 16:09, Filip Rembiałkowski wrote:
> Just an idea - how long does it take to run _only_
> CREATE TEMP TABLE foo AS
>
>
>
>
> On Thu, Dec 13, 2012 at 4:37 PM, Lutz Fischer
> wrote:
>> Hi
>>
>&g
given time there were no concurrent access to any of the
involved tables.
Has anybody some idea why the insert takes so long and/or how to speed
things up a bit? I could live with something like half an hour - better
would be in minutes.
Thanks for any responds,
Lutz Fischer
--
The
