Skip site navigation (1) Skip section navigation (2)

Re: psql large RSS (1.6GB)

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: TTK Ciar <ttk2(at)hardpoint(dot)ciar(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: psql large RSS (1.6GB)
Date: 2004-10-31 10:27:01
Message-ID: 1099218421.2636.0.camel@teetnang (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
В Срд, 27.10.2004, в 09:57, TTK Ciar пишет:

> brad=# explain analyse select ServerDisks.servername,ServerDisks.diskserial,ServerDisks.diskmountpoint,,DiskFiles.md5 from DiskFiles,ServerDisks where DiskFiles.diskserial=ServerDisks.diskserial;
>                           QUERY PLAN                                                         
> ------------------------------------------------------------------
>  Hash Join  (cost=22.50..65.00 rows=1000 width=274) (actual time=118.584..124653.729 rows=10133349 loops=1)
>    Hash Cond: (("outer".diskserial)::text = ("inner".diskserial)::text)
>    ->  Seq Scan on diskfiles  (cost=0.00..20.00 rows=1000 width=198) (actual time=7.201..31336.063 rows=10133349 loops=1)
>    ->  Hash  (cost=20.00..20.00 rows=1000 width=158) (actual time=90.821..90.821 rows=0 loops=1)
>          ->  Seq Scan on serverdisks  (cost=0.00..20.00 rows=1000 width=158) (actual time=9.985..87.364 rows=2280 loops=1)
>  Total runtime: 130944.586 ms

You should run ANALYZE on your database once in a while.

Markus Bertheau <twanger(at)bluetwanger(dot)de>

In response to

pgsql-performance by date

Next:From: brewDate: 2004-10-31 18:38:55
Subject: Thanks Chariot Solutions
Previous:From: Dustin SallingsDate: 2004-10-31 06:02:54
Subject: Re: psql large RSS (1.6GB)

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group