Chris Angelico wrote:
>> I never heard of a raidle. What is that?
> Google showed up this:
>
> http://www.techrepublic.com/article/non-standard-raid-levels-primer-raid-1e/6181460
>
> Seems it's "raid 10 for odd numbers of disks".
Ah, thanks! I missed it when I searched because I mis-scanned it
On Tue, Dec 18, 2012 at 12:22 AM, Kevin Grittner wrote:
> Lutz Fischer wrote:
>
>> I am running postgresql 9.2 on a windows 2008 R2 server with 256 GB and
>> the database is on something like a raid 1+0 (actually a raid1e)
>> consisting of 3x4TB disks (limit of what could easily be fitted into the
Lutz Fischer wrote:
> I am running postgresql 9.2 on a windows 2008 R2 server with 256 GB and
> the database is on something like a raid 1+0 (actually a raid1e)
> consisting of 3x4TB disks (limit of what could easily be fitted into the
> server).
I never heard of a raidle. What is that? What sort
First try put inserts to temporary table, a then insert from temporary to
your table
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/problem-with-large-inserts-tp5736844p5736867.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via p
Lutz Fischer wrote:
> I have currently some trouble with inserts into a table
>
> INSERT INTO LPP (PPID, LID)
> SELECT DISTINCT PPid, LID FROM
> (SELECT * FROM PP WHERE s_id = sid) pp
> INNER JOIN
> has_protein hp1
> ON pp.p1id = hp1.pid
> INNER
Hi
I have currently some trouble with inserts into a table
INSERT INTO LPP (PPID, LID)
SELECT DISTINCT PPid, LID FROM
(SELECT * FROM PP WHERE s_id = sid) pp
INNER JOIN
has_protein hp1
ON pp.p1id = hp1.pid
INNER JOIN
has_protein hp2
