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

Re: Less rows -> better performance?

From: Richard Huxton <dev(at)archonet(dot)com>
To: Andreas Hartmann <andreas(at)apache(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Less rows -> better performance?
Date: 2008-07-21 11:06:11
Message-ID: 48846DA3.2090308@archonet.com (view raw or flat)
Thread:
Lists: pgsql-performance
Andreas Hartmann wrote:
> Dear PostgreSQL community,
> 
> first some info about our application:
> 
> - Online course directory for a University
> - Amount of data: complete dump is 27 MB
> - Semester is part of primary key in each table
> - Data for approx. 10 semesters stored in the DB
> - Read-only access from web application (JDBC)
> 
> Our client has asked us if the performance of the application could be
> improved by moving the data from previous years to a separate "archive"
> application. 

If you had 27GB of data maybe, but you've only got 27MB - that's 
presumably all sitting in memory.

What in particular is slow?

-- 
   Richard Huxton
   Archonet Ltd

In response to

Responses

pgsql-performance by date

Next:From: Valentin BogdanovDate: 2008-07-21 11:19:15
Subject: Perl/DBI vs Native
Previous:From: Andreas HartmannDate: 2008-07-21 10:50:42
Subject: Less rows -> better performance?

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