Hi there!
We currently have a database table that's laid out something like this:
id int
date1 date
belongs_to date
type varchar(1)
type_fk int
start_time time
end_time time
location_fk int
department_fk int
value decimal
Where each row represents some data throughout the day
Creating an inherit table without a trigger would be a good idea? Like a
kind of partitioning, but simpler.
Cheers,
Matheus de Oliveira
http://i.imgur.com/sva4H.png
In the image above, please find the traffic we have seen from our main
postgresql node to our cloud backup.
A few notes on that image:
a) We're only interested in looking at the blue - outbound - traffic
b) In general, this pipe is almost exclusively for WAL usage
On Sat, Aug 11, 2012 at 12:15:11AM +0200, Strahinja Kustudić wrote:
> Is there a way to make the autovacuum daemon more aggressive, since I'm not
> exactly sure how to do that in this case? Would that even help? Is there
> another way to remove this index bloat?
http://www.depesz.com/index.php/201
