pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mitch Vincent <mitch@venux.net>
To: xuyifeng <jamexu@telekbird.com.cn>
To: Roberto Mello <rmello@cc.usu.edu>
Cc: pgsql-hackers@postgreSQL.org
Subject: Re: why the DB file size does not reduce when 'delete'the data in DB?
Date: Sun, 4 Mar 2001 13:37:11 -0500
Message-ID: <00d501c0a4da$21a45ee0$0200000a@windows> (raw)
References: <Pine.BSF.4.33.0103020804370.88613-100000@mobile.hub.org>
	<008601c0a44f$0d657b20$cc01a8c0@xyf>
	<20010303194029.A31190@cc.usu.edu>
	<000901c0a47a$e03c7dc0$cc01a8c0@xyf>

> I know your situations,  your DB is not updated and inserted lots of
records in few minutes,
> mine is difference,  I have a real time Stock Trading  system, you know,
stock, its price
> is changed every minute or even every second ,  I need update and insert
delta change into DB,
> draw their trend graphics,  suppose there are 3000 stocks in market,
there maybe 9000 records
> changed and inserted in one minutes, because PGSQL's storage manager
problem( it does not
> reuse deleted record space),  in 4 hours trading period,  my harddisk can
be full filled.  because in
> the period, the table indeed gets very large, doing VACCUME is impossible
in realtime, it will lock
> out other clients too long time,  my point of view is PGSQL is fit for
static or small changed database,
> not fit for lots of change in short time.

It's admitadly a problem so I don't think you need to convince everyone that
it's not the best way to handle things :-)

I hate to say it, but your options currently are to upgrade your storage
device or change databases... I think I'd fork out some cash for some new
hardware verses buying a commercial database or putting up with the missing
features of MySQL..

All my humble opinion of course, I wish you the best of luck.

-Mitch




view thread (12+ messages)  latest in thread

Message-ID: <00d501c0a4da$21a45ee0$0200000a@windows>
Permalink:  ../00d501c0a4da$21a45ee0$0200000a@windows/
Also on:    postgresql.org/message-id/00d501c0a4da$21a45ee0$0200000a@windows

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: mitch@venux.net, jamexu@telekbird.com.cn, rmello@cc.usu.edu, pgsql-hackers@postgreSQL.org
  Subject: Re: why the DB file size does not reduce when 'delete'the data in DB?
  In-Reply-To: <00d501c0a4da$21a45ee0$0200000a@windows>
  References: <Pine.BSF.4.33.0103020804370.88613-100000@mobile.hub.org> <008601c0a44f$0d657b20$cc01a8c0@xyf> <20010303194029.A31190@cc.usu.edu> <000901c0a47a$e03c7dc0$cc01a8c0@xyf> <00d501c0a4da$21a45ee0$0200000a@windows>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox