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

Re: PGSQL Capacity

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: PGSQL Capacity
Date: 2005-05-09 19:32:18
Message-ID: 20050509193218.GB12502@uio.no (view raw or flat)
Thread:
Lists: pgsql-performance
On Mon, May 09, 2005 at 09:22:40PM +0200, bouchia(dot)nazha(at)free(dot)fr wrote:
> How can i know a capacity of a pg database ?
> How many records my table can have ?
> I saw in a message that someone have 50 000 records it's possible in a table ?
> (My table have 8 string field (length 32 car)).
> Thanks for your response.

You can have several million records in a table easily -- I've done 10
million personally, but you can find people doing that many records a _day_.
Hitting 1 billion records should probably not be impossible either -- it all
depends on your hardware, and perhaps more importantly, what kind of queries
you're running against it. 50000 is absolutely no problem at all.

/* Steinar */
-- 
Homepage: http://www.sesse.net/

In response to

Responses

pgsql-performance by date

Next:From: John A MeinelDate: 2005-05-09 19:40:52
Subject: Re: PGSQL Capacity
Previous:From: bouchia.nazhaDate: 2005-05-09 19:22:40
Subject: PGSQL Capacity

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