| Subject | RE: [firebird-support] Gbak, sweep, and the page cache |
|---|---|
| Author | Rick Debay |
| Post date | 2007-04-19T17:27:13Z |
I assume nbackup would have the same side effect? It's tempting to make
an incremental backup every hour, but I'd hate to flush the working set
in the page cache every time.
-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ann W. Harrison
Sent: Thursday, April 19, 2007 12:53 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Gbak, sweep, and the page cache
Rick Debay wrote:
(not easy) to limit the number of pages a particular query can use, or
identify a massive serial read and restrict it to a few data pages at a
time. It will still need pointer pages, etc.
Regards,
Ann
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Resources item on the
main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links
Disclaimer: This message (including attachments) is confidential and may be privileged. If you have received it by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. RxStrategies, Inc. shall not be liable for the improper or incomplete transmission of the information contained in this communication or for any delay in its receipt or damage to your system. RxStrategies, Inc. does not guarantee that the integrity of this communication has been maintained nor that this communication is free from viruses, interceptions or interference.
an incremental backup every hour, but I'd hate to flush the working set
in the page cache every time.
-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ann W. Harrison
Sent: Thursday, April 19, 2007 12:53 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Gbak, sweep, and the page cache
Rick Debay wrote:
> Would it be worthwhile to submit a feature request that theseIt's not feasible to circumvent the page cache. It _might_ be possible
> utilities circumvent the page cache, or is this not feasible due to
> architecture or implementation?
(not easy) to limit the number of pages a particular query can use, or
identify a massive serial read and restrict it to a few data pages at a
time. It will still need pointer pages, etc.
Regards,
Ann
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Resources item on the
main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links
Disclaimer: This message (including attachments) is confidential and may be privileged. If you have received it by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. RxStrategies, Inc. shall not be liable for the improper or incomplete transmission of the information contained in this communication or for any delay in its receipt or damage to your system. RxStrategies, Inc. does not guarantee that the integrity of this communication has been maintained nor that this communication is free from viruses, interceptions or interference.