> ---In firebird-support@yahoogroups.com, <kragh.thomas@...> wrote :
>
> Hey Vlad
Sad. Probably, table have a lot of indices ? IO subsystem, amount of RAM, page size and page cache size also
matters. Also interesting if filesystem is mounted with "barrier=on" option
It still will clean up record versions left after UPDATE's
> If i only count the deleted rows, the problem is the same, and the server hangs while performing garbage collection.
Sad. Probably, table have a lot of indices ? IO subsystem, amount of RAM, page size and page cache size also
matters. Also interesting if filesystem is mounted with "barrier=on" option
> On the other hand, if I count the rows not deleted, no garbage collection is performed - that makes sens as the index
> on created makes sure that no delete records/rows are accessed. This is useful to know as i can make sure that other
> parts of the application never issues a query for rows older that 6 months.
> on created makes sure that no delete records/rows are accessed. This is useful to know as i can make sure that other
> parts of the application never issues a query for rows older that 6 months.
It still will clean up record versions left after UPDATE's
> Now the garbage collection will be deferred and happen during backup. Is it possible that the same "hang" behavior will
> happen during backup as a result of the deferred garbage collection?
gbak have no magic, it just reads the tables and put data into backup file.
Regards,
Vlad
> happen during backup as a result of the deferred garbage collection?
gbak have no magic, it just reads the tables and put data into backup file.
Regards,
Vlad
__._,_.___
Posted by: hvlad@users.sourceforge.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (10) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
.
__,_._,___
No comments:
Post a Comment