On Sat, 18 Oct 2014 11:34:18 -0400, Tom Lane wrote:
> If the comparison value is outside the range recorded in the histogram,
> and there's a suitable index available, the planner uses the index to
> find out the actual column min or max rather than believing the
histogram
> completely. See get
Hi everyone. I have a view setup like so:
create view myview as
select
department,
employee_id,
report_status,
sum(reports) reports
from logger.reports
group by department, employee_id, report_status;
Which gives me the total number of reports by status, which is either
'published
writes:
> Yesterday I was trying to calculate by hand the row number estimates using
> the examples from
> http://www.postgresql.org/docs/9.3/static/row-estimation-examples.html
> It is usually correct, except when you try to get an estimate near the
> first (or last) histogram bound. Let me demon
Stephen Woodbridge writes:
> On 10/18/2014 5:38 AM, Andres Freund wrote:
>>> 3. What do for logging classes when integrating C++ code into postgresql?
>> I don't really know what you want to do here. My guess is that it'd be
>> most appropriate to map the logging onto postgres' internal
>> loggin
On 10/18/2014 5:38 AM, Andres Freund wrote:
On 2014-10-17 19:59:54 -0400, Stephen Woodbridge wrote:
Hi,
I've been writing C++ code that needs to get wrapped into a postgresql
extension and it has a few singleton classes like:
1. Config object that holds some general configuration information.
On 2014-10-17 19:59:54 -0400, Stephen Woodbridge wrote:
> Hi,
>
> I've been writing C++ code that needs to get wrapped into a postgresql
> extension and it has a few singleton classes like:
>
> 1. Config object that holds some general configuration information.
> 2. Stats object for global stats
Hi,
Yesterday I was trying to calculate by hand the row number estimates using
the examples from
http://www.postgresql.org/docs/9.3/static/row-estimation-examples.html
It is usually correct, except when you try to get an estimate near the
first (or last) histogram bound. Let me demonstrate with an
Hello,
2014-10-18 3:59 GMT+04:00 Stephen Woodbridge :
> Hi,
>
> I've been writing C++ code that needs to get wrapped into a postgresql
> extension and it has a few singleton classes like:
>
> 1. Config object that holds some general configuration information.
> 2. Stats object for global stats co
Ross Dougherty wrote:
> Hi all,
>
> We run database servers that each contain multiple customer databases.
> We would like to give customers access to their own database but even
> though they are unable to connect to the databases of other customers
> due to connect grants they are still able t
