Postgres Pro
Downloads
Home   >   mailing lists

Re: Very long deletion time on a 200 GB database - Mailing list pgsql-performance

From lephongvu
Subject Re: Very long deletion time on a 200 GB database
Date
Msg-id 1330317188314-5517941.post@n5.nabble.com
Whole thread Raw
In response to Re: Very long deletion time on a 200 GB database  ("Reuven M. Lerner" <reuven@lerner.co.il>)
List pgsql-performance
Tree view 
I have a question.

Your data is growing 1Gb by 1 day.

Can we use another Disk or partition to continue archive data ?
I mean, do postgreSql support a Layering System for archive data ?

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Very-long-deletion-time-on-a-200-GB-database-tp5507359p5517941.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

pgsql-performance by date:

Previous
From: Cédric Villemain
Date:
Subject: Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
Next
From: Shaun Thomas
Date:
Subject: Re: Very long deletion time on a 200 GB database