| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | roopa perumalraja <roopabenzer(at)yahoo(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Maximum size of database |
| Date: | 2006-10-18 03:20:17 |
| Message-ID: | 20061018032017.GA61385@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Oct 17, 2006 at 07:26:25PM -0700, roopa perumalraja wrote:
> I would like to know that what can be the maximum size of database in
> postgres 8.1.4.
http://www.postgresql.org/docs/faqs.FAQ.html#item4.4
> Currently my database size is 37GB & its pretty slow. I wonder if
> its b'cos of huge amount of data in it.
37GB isn't all that huge; as the FAQ mentions, much larger databases
exist. Without more information we'll have to ask some of the
standard questions:
What's your hardware configuration?
What operating system and version are you using?
What are your non-default postgresql.conf settings?
Are you vacuuming and analyzing the database regularly?
How much concurrent activity do you have?
Does anything other than PostgreSQL run on the box?
If you have a specific query that's slow then please post the EXPLAIN
ANALYZE output. Also, you might get more help on the pgsql-performance
list.
--
Michael Fuhr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Edward Macnaghten | 2006-10-18 03:23:41 | Re: Maximum size of database |
| Previous Message | Michael Glaesemann | 2006-10-18 03:14:00 | Re: Fixed-point scalars? |