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

Re: am i creating a performance bottleneck?

From: n0g0013 <ttw+pgsql(at)cobbled(dot)net>
To: Mary Anderson <maryfran(at)demog(dot)berkeley(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: am i creating a performance bottleneck?
Date: 2007-07-18 10:44:18
Message-ID: 20070718104418.GD16194@holyman.cobbled.net (view raw or flat)
Thread:
Lists: pgsql-admin
On 17.07-17:31, Mary Anderson wrote:
[ ... ]
> I am most worried about the second select, with its 'NOT EXISTS' 
> statement slowing everything down.  I would put appropriate indexes on 
> this -- namely an index on series for data and an index on dhd for 
> da_id.   My user community is a bunch of academics, so I am not under 
> the performance constraints I would have for a business application.
> 
> Would it help performance if I denormalized the database by attaching 
> series to the data_has_dimensions table?

to be honest i couldn't really understand your SQL but that probably
says more about me than you.  either way i don't think you need to
worry about the NOT EXISTS statement.  generally, serialising select
statements is better than joining and would suggest that if your series
data has 10,000 rows (assuming 10,00 was a typo) then i wouldn't merge
that data with another table (it also will simply mean a larger,
disjoint table, essentially equivelant to the join table required your
queries and thus may well cost you in overall performance).  i would
suggest you try to restructure you queries to serialise the 'series'
select joins (and preferably only doing it once), thereby reducing
the final join table to a minimum.

-- 
        t
 t
                 w

In response to

pgsql-admin by date

Next:From: Michael MonnerieDate: 2007-07-18 10:56:57
Subject: Re: syslog: log line length?
Previous:From: John HorvathDate: 2007-07-18 08:34:12
Subject: Setting usesuper bit for user postgres.

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