pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: nbarraza@uolsinectis.com.ar
To: pgsql-performance@postgresql.org
Subject: Performance related to size of tables
Date: Fri, 12 Dec 2003 15:04:49 -0300 (GMT+3)
Message-ID: <20031212180449.697FD6C58F@tino.sinectis.com.ar> (raw)

Hi everyone,
I found that performance get worse as the size of a given table 
increases. I mean, for example I´ve just run some scripts shown in 

http://www.potentialtech.com/wmoran/postgresql.php

I understand that those scripts are designed to see the behavior of postgresql under different filesystems. However, since them generate
a lot of I/O activity, I think they can be used to adjust some 
configuration parameters. In that way, I increased the number of tuples inserted in the initial table to 2000000 and 3000000. What 
I saw is that the running time goes from 3 min., to 11 min. My question is, is it possible to use that test to tune 
some parameters?, if the answer is yes, what parameters should I change to get shorter running times?

Thanks a lot

Nestor



view thread (2+ messages)  latest in thread

Message-ID: <20031212180449.697FD6C58F@tino.sinectis.com.ar>
Permalink:  ../20031212180449.697FD6C58F@tino.sinectis.com.ar/
Also on:    postgresql.org/message-id/20031212180449.697FD6C58F@tino.sinectis.com.ar

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: nbarraza@uolsinectis.com.ar
  Subject: Re: Performance related to size of tables
  In-Reply-To: <20031212180449.697FD6C58F@tino.sinectis.com.ar>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox