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 S
warrant a flame, but I think 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
Subje
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
explain analyze verbose select * from tk_ ;
roopa perumalraja wrote:
Hi
Thanks for your reply.
explain select * from tk_20060403;
QUERY PLAN
--
Seq S
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
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
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 = 2 autovaccum = on 4) Yes, I am vacuuming & analyzing the datab
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 ca
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 hug
Hi 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. Thanks in advance. Roopa
How low will we go? Check out Yahoo! Messengers low PC-to-Phone c
10 matches
Mail list logo
