[Firebird-devel] Maintenance/outage for tracker.firebirdsql.org and web.firebirdsql.org from Sept 13 08:00 to Sept 14 18:00 (EDT)

2014-09-08 Thread Leyne, Sean
All, As previously mentioned, BroadView is moving offices. Well, this weekend we are moving our server room equipment to our new location. Although the move should be largely completed on the 13th, there may be issues which could drag into the 14th. This will affect the project tracker.firebi

Re: [Firebird-devel] Difference in result when GROUP BY is used

2014-09-08 Thread Leyne, Sean
Matt, > I am have a query to perform aggregation functions on data retrieved from > FB. This result differs when using GROUP BY. Query looks something like: > > 'select > symbol, > sum(price * vol)/sum(vol) as VWAP, > sum(price) as SUMPRICE > > from Table1 > where symbol in('XYZ')

[Firebird-devel] Odp: Re Planning the post v3 development

2014-09-08 Thread liviusliv...@poczta.onet.pl
Hi, What problem do you have with monitoring FB by nagios. We collect stats from FB for nagios without problem Regards, Karol Bieniaszewski - Reply message - Od: "marius adrian popa" Do: "For discussion among Firebird Developers" Temat: [Firebird-devel] Re Planning the post v3 devel

Re: [Firebird-devel] Re Planning the post v3 development

2014-09-08 Thread marius adrian popa
Snmp support is usually done in an external agent or as plugin in the monitoring solution : nagios ... On Tue, Sep 2, 2014 at 5:14 PM, Martin Köditz wrote: > Hi Dmitry, > > > > responding to your request, there is one thing I’m really missing. What do > you think about a SNMP function. > > > > C

[Firebird-devel] [FB-Tracker] Created: (CORE-4545) Do not cache blob data pages

2014-09-08 Thread Dimitry Sibiryakov (JIRA)
Do not cache blob data pages Key: CORE-4545 URL: http://tracker.firebirdsql.org/browse/CORE-4545 Project: Firebird Core Issue Type: Improvement Components: Engine Affects Versions: 4.0 Initial

Re: [Firebird-devel] Usage of BLB_large_scan

2014-09-08 Thread Vlad Khorsun
08.09.2014 10:20, Dimitry Sibiryakov wrote: > 08.09.2014 8:37, Vlad Khorsun wrote: >> Corresponding number of LRU pages will be evicted, yes. > > I cannot imagine an application pattern that read the same BLOB > repeatedly. Can you? > > May be it has sense to cache only BLOB pointer p

Re: [Firebird-devel] Usage of BLB_large_scan

2014-09-08 Thread Dimitry Sibiryakov
08.09.2014 8:37, Vlad Khorsun wrote: > Corresponding number of LRU pages will be evicted, yes. I cannot imagine an application pattern that read the same BLOB repeatedly. Can you? May be it has sense to cache only BLOB pointer pages, but not data to prevent performance penalty for