On Sun, Jan 16, 2011 at 12:28 PM, Andy Colson wrote:
On 01/16/2011 10:44 AM, Mag Gam wrote:
I am running Redhat 5.2 Linux with Postgresql 8.4.4;
When my disk space is 90% free the database performance is very good.
However, when it reaches close to 20% free the database performance is
bad. I
On 18/01/2011 13:43, Mag Gam wrote:
Purge meaning, stop postgresql, rm -rf $PGDATA, recreate the
environment, and start up postgresql again.
Goodness, that's fairly dramatic. What's wrong with DROP DATABASE? :-)
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-gen
Purge meaning, stop postgresql, rm -rf $PGDATA, recreate the
environment, and start up postgresql again.
On Tue, Jan 18, 2011 at 8:32 AM, Bill Moran wrote:
> In response to Mag Gam :
>
>> Hi Andy,
>>
>> No, I don't shrink the database. I simply purge the whole thing and
>> then let it populate
In response to Mag Gam :
> Hi Andy,
>
> No, I don't shrink the database. I simply purge the whole thing and
> then let it populate again. The data isn't too critical.
What does "purge" mean? Are you doing an SQL DELETE, or a TRUNCATE,
or dropping the DB and recreating?
Each of these functions
Hi Andy,
No, I don't shrink the database. I simply purge the whole thing and
then let it populate again. The data isn't too critical.
The disks I have are internal SAS disks. I get around 150MB/sec write
and 250MB/sec read. Its a RAID1 .
ps does show idle in transactions. I've never checked pg_l
On 01/16/2011 10:44 AM, Mag Gam wrote:
I am running Redhat 5.2 Linux with Postgresql 8.4.4;
When my disk space is 90% free the database performance is very good.
However, when it reaches close to 20% free the database performance is
bad. I know its bad because I see a lot of 'D' next to 'postgre
I am running Redhat 5.2 Linux with Postgresql 8.4.4;
When my disk space is 90% free the database performance is very good.
However, when it reaches close to 20% free the database performance is
bad. I know its bad because I see a lot of 'D' next to 'postgresql'
process when running top and I see a
