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 RAM3) shared_buffers = 2 autovaccum = on4) Yes, I am vacuuming analyzing the database once every day.5)
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
HiThanks 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 [EMAIL PROTECTED] wrote: also,
explain analyze verbose select * from tk_ ;
roopa perumalraja wrote:
Hi
Thanks for your reply.
explain select * from tk_20060403;
QUERY PLAN
--
Seq
perumalrajaSent: Wednesday, October 18,
2006 8:10 AMTo: pgsql-general@postgresql.orgCc: Michael
FuhrSubject: Re: [GENERAL] Maximum size of
database
Thanks for your reply.
I have answered your questions below.
1 2) System: Microsoft Windows XP
Professional Version
2002
Computer
in general the *Nix OS
versions may have better disk I/O.
Greg W.
-Original Message-
From: [EMAIL PROTECTED] on behalf of roopa perumalraja
Sent: Wed 10/18/2006 12:41 AM
To: pgsql-general@postgresql.org
Cc: Michael Fuhr; louis gonzales
Subject:Re: [GENERAL] Maximum size
On Wed, 2006-10-18 at 00:41 -0700, roopa perumalraja wrote:
Hi
Thanks for your reply.
explain select * from tk_20060403;
QUERY
PLAN
--
Seq Scan on
HiI would like to know that what can be the maximum size of database in postgres 8.1.4. Currently my database size is 37GB its prettyslow. I wonder if its b'cos of huge amount of data in it.Thanks in advance. Roopa
How low will we go? Check out Yahoo! Messengers low PC-to-Phone call
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
roopa perumalraja wrote
I would like to know that what can be the maximum size of database in
postgres 8.1.4. Currently my database size is 37GB its pretty slow.
I wonder if its b'cos of huge amount of data in it.
http://www.postgresql.org/docs/faqs.FAQ.html#item4.4
Slowness reason
10 matches
Mail list logo