[EMAIL PROTECTED] writes:
> I'm trying to vacuum the tables, but the pg_xlog is gettting very big
> (filling up the harddrive). As an estimate, how much space do you need to
> vacuum a 30GB table (data + indexes) ?
Not a lot, if you apply the previously posted patch to truncate the xlog
a little
t;[EMAIL PROTECTED]To: [EMAIL PROTECTED]
pa.us> cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Requirements for a
data
TED]
M> cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Requirements for a
database server
22/0
On Tuesday, July 17, 2001, at 10:52 PM,
[EMAIL PROTECTED] wrote:
> Hi,
> I have been using postgres for the last year now. The database
> has grown
> from a mere few MBs to over 100GB data and expected to top up
> 300GB by the
> end of the year.
Interesting. The most I've ever seen a PG data
Re: [ADMIN] Requirements for a
database server
19/07/2001
=?iso-8859-1?Q?Ragnar_Kj=F8rstad?= <[EMAIL PROTECTED]> writes:
> On Thu, Jul 19, 2001 at 07:38:25AM +0200, [EMAIL PROTECTED] wrote:
>> Since I have a number of heavy inserts per day, dropping the indexes and
>> recreating them could be an option. Only problem I see is that to
>> recreate them th
On Thu, Jul 19, 2001 at 07:38:25AM +0200, [EMAIL PROTECTED] wrote:
> Since I have a number of heavy inserts per day, dropping the indexes and
> recreating them could be an option. Only problem I see is that to
> recreate them they take alot of time, at which queries will be tremendously
> slow.
TED]
pa.us> cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Requirements for a
database server
18/0
Subject: Re: [ADMIN] Requirements for a
database server
[EMAIL PROTECTED] writes:
> I have been using postgres for the last year now. The database has grown
> from a mere few MBs to over 100GB data and expected to top up 300GB by the
> end of the year. Lately performance of queries, inserts, updates has
> continued to grow worse as the dataset has gr
Robert -
You mention having a PostgreSQL database in production for around a year.
May I ask what version it is? I'm guessing you're still at 6.5.X,
in which case, I'd suggest an upgrade to 7.1.2, before doing anything
more drastic. Not only are there bug fixes, many improving stability
of the s
ndy Samuel"
ities.com> cc:
Subject: Re: [ADMIN] Requirements for
a database server
Hi,
I have been using postgres for the last year now. The database has grown
from a mere few MBs to over 100GB data and expected to top up 300GB by the
end of the year. Lately performance of queries, inserts, updates has
continued to grow worse as the dataset has grown larger, even though most
13 matches
Mail list logo
