[PERFORM] CPU bound

2010-12-12 Thread Royce Ausburn
Hi all, I notice that when restoring a DB on a laptop with an SDD, typically postgres is maxing out a CPU - even during a COPY. I wonder, what is postgres usually doing with the CPU? I would have thought the disk would usually be the bottleneck in the DB, but occasionally it's not. We're emb

Re: [PERFORM] SELECT INTO large FKyed table is slow

2010-12-12 Thread Robert Haas
On Thu, Dec 2, 2010 at 3:36 AM, Mario Splivalo wrote: > On 12/01/2010 09:43 AM, Pierre C wrote: >> >> Note that in both cases postgres reports that the FK checks take 92-120 >> milliseconds... which is a normal time for about 4000 rows. >> Inserting 4000 lines with just a few fields like you got s

Re: [PERFORM] UNION and bad performance

2010-12-12 Thread pasman pasmaƄski
> UNION will remove all duplicates, so that the result additionally requires to > be sorted. >Right, to avoid the SORT and UNIQUE - operation you can use UNION ALL by the way maybe apply hashing to calculate UNION be better ? pasman -- Sent via pgsql-performance mailing list (pg