On Sat, Dec 10, 2011 at 7:27 PM, Jon Nelson wrote:
> I was experimenting with a few different methods of taking a line of
> text, parsing it, into a set of fields, and then getting that info
> into a table.
>
> The first method involved writing a C program to parse a file, parse
> the lines and ou
"Anibal David Acosta" writes:
> Tables has insert (in bulk every 3 minutes) and delete one per day (delete
> records older than XX days)
No updates at all, just inserts and a daily delete?
If so, you're wasting your time even thinking about suppressing
autovacuum, because it won't fire on this
On 12.12.2011 16:25, Anibal David Acosta wrote:
I have a couple of tables with about 400millions of records increasing about
5 millions per day.
I think that disabling autovac over those tables, and enabling daily manual
vacuum (in some idle hour) will be better.
I am right?
Possibly. If the
The postgres version is 9.0.4 on a Windows Server 2008 (planning to upgrade to
9.1)
Tables has insert (in bulk every 3 minutes) and delete one per day (delete
records older than XX days)
There are not much additional relevant information.
Thanks!
De: Craig Ringer [mailto:ring...@r
Top-posting because this is context free:
You need to provide more info for anybody to help you. Are the tables
append-only or are deletes/updates also performed? Also this:
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
On Dec 12, 2011 10:26 PM, "Anibal David Acosta" wrote:
> I h
I have a couple of tables with about 400millions of records increasing about
5 millions per day.
I think that disabling autovac over those tables, and enabling daily manual
vacuum (in some idle hour) will be better.
I am right?
Is possible to exclude autovacuum over some tables?
Tha
