Re: Maximum size of database

explain analyze verbose select * from tk_.... ;

roopa perumalraja wrote:

> Hi
>
> Thanks for your reply.
>
> explain select * from tk_20060403;
> QUERY PLAN
> --------------------------------------------------------------------------
> Seq Scan on tk_20060403 (cost=0.00..95561.30 rows=3609530 width=407)
> (1 row)
> will this help?
>
> */louis gonzales <gonzales(at)linuxlouis(dot)net>/* wrote:
>
> also, run
> EXPLAIN
> on any command, show the results of this. In particular, if you have
> some commands that are taking 'even longer?'
>
>
>
> roopa perumalraja wrote:
>
> > Thanks for your reply.
> >
> > I have answered your questions below.
> >
> > 1 & 2) System: Microsoft Windows XP Professional
> > Version 2002
> > Computer: Intel Pentium CPU 3.40GHz, 960MB of RAM
> >
> > 3) shared_buffers = 20000
> > autovaccum = on
> >
> > 4) Yes, I am vacuuming & analyzing the database once every day.
> >
> > 5) No concurrent activities, means I run one command at a time.
> >
> > 6) Nothing else running on the box other than Postgres.
> >
> > I hope these answers will try to solve my problem. Thanks again.
> >
> > Roopa
> > */Michael Fuhr /* wrote:
> >
> > 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
> >
> >
> >
> >
> > signature
> >
> >
> ------------------------------------------------------------------------
> > Get your own web address for just $1.99/1st yr
> >
>
> ------------------------------------------------------------------------
> Do you Yahoo!?
> Everyone is raving about the all-new Yahoo! Mail.
> <http://us.rd.yahoo.com/evt=42297/*http://advision.webevents.yahoo.com/mailbeta>

--
Email: louis(dot)gonzales(at)linuxlouis(dot)net
WebSite: http://www.linuxlouis.net
"Open the pod bay doors HAL!" -2001: A Space Odyssey
"Good morning starshine, the Earth says hello." -Willy Wonka