On Sun, Feb 10, 2013 at 12:10 PM, Jeff Janes wrote:
> On Tue, Feb 5, 2013 at 2:00 PM, Kevin Grittner wrote:
> >
> > OK, the estimate was 13 million and there were actually 13.8
> > million, but it is a random sample used to generate estimates.
> > That seems worse than average, but close enough
Hello
2013/2/21 Josh Kupershmidt :
> On Tue, Feb 19, 2013 at 6:00 AM, Pavel Stehule
> wrote:
>> 2013/2/16 Pavel Stehule :
>>> 2013/2/16 Tom Lane :
I think it has come up before. I wouldn't object to a pg_dump option to
add IF EXISTS to all the drop commands (though changing the defaul
On 23 February 2013 14:09, wrote:
> My problem now is that I it's always displayed with the dashes in between,
> even when I want to show the EAN13. As far as I know EANs are never shown
> with the dashes.
Right, they're not. But then, contrib/isn also sanitises both ISBN
ranges and EAN country
Jeff Janes writes:
> On Friday, February 22, 2013, Tom Lane wrote:
>> Try increasing from_collapse_limit to 11 or more.
> I've increased it to 20 and still no luck.
Huh --- that improved the results for me.
> I've stripped it down to this:
I'm not sure if that's exactly the same issue the OP i
On Friday, February 22, 2013, Tom Lane wrote:
> Jeff Janes writes:
> > The slowness was introduced with this:
> > Use parameterized paths to generate inner indexscans more flexibly.
>
> Try increasing from_collapse_limit to 11 or more.
>
I've increased it to 20 and still no luck.
>
> I'm n
The following bug has been logged on the website:
Bug reference: 7903
Logged by: Kurt Roeckx
Email address: k...@roeckx.be
PostgreSQL version: 9.2.3
Operating system: all
Description:
Hi,
I was looking at the isn extention to store EAN13 value. A lot of those
that I
Okay, I have some more info.
Some background info. This one table gets so many changes, I CLUSTER it
each night. However, after I do this. The statistics still appear to be
incorrect. Even after I do a "select pg_stat_reset();" Followed by 3
ANALYZE at default_statistics_target as 1, 10, and 10
