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

Re: performance tuning queries

From: Mario Weilguni <mweilguni(at)sime(dot)com>
To: Kevin Kempter <kevink(at)consistentstate(dot)com>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: performance tuning queries
Date: 2008-11-27 10:09:28
Message-ID: (view raw or whole thread)
Lists: pgsql-performance
Kevin Kempter schrieb:
> Hi All;
> I'm looking for tips / ideas per performance tuning some specific queries. 
> These are generally large tables on a highly active OLTP system 
> (100,000 - 200,000 plus queries per day)
> First off, any thoughts per tuning inserts into large tables. I have a large 
> table with an insert like this:
> insert into public.bigtab1 (text_col1, text_col2, id) values ...
>                 QUERY PLAN                
> ------------------------------------------
>  Result  (cost=0.00..0.01 rows=1 width=0)
> (1 row)
> The query cost is low but this is one of the slowest statements per pgfouine
Do you insert multiple values in one transaction, or one transaction per 

In response to

pgsql-performance by date

Next:From: Chavdar KopoevDate: 2008-11-27 16:39:51
Subject: Re: many to many performance
Previous:From: PFCDate: 2008-11-27 08:38:36
Subject: Re: performance tuning queries

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