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@linuxlouis.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.gonzales@linuxlouis.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