Hi, all.
I wrote a function and during testing it I came across the strange
behaviour.
Function runtime is about 200ms first 5 times, 6th and futher calls takes
~22000 ms.
I simplified my schema, you can see it in attached file.
I've tested on 9.4beta3 and 9.3.5.
When I removed security_barrier f
On 10/20/2014 08:26 PM, Jerry Levan wrote:
> I just upgraded one of my Mac computers to Yosemite and am having a
> small problem.
My preliminary investigation, limited by not having access to a Mac,
suggests that there's a lot more than a "small" problem for people
who're using the built-in Postgr
Hi
On Tue, Oct 21, 2014 at 12:53 PM, Ilya I. Ashchepkov wrote:
> I wrote a function and during testing it I came across the strange
> behaviour.
> Function runtime is about 200ms first 5 times, 6th and futher calls takes
> ~22000 ms.
> I simplified my schema, you can see it in attached file.
> I'
On Tue, Oct 21, 2014 at 7:04 PM, Craig Ringer wrote:
> This needs urgent investigation by community members with access to
> Apple hardware. Anyone who is still on 10.9, or who can downgrade to
> 10.9, do some tests, and upgrade to 10.10 again, please get in touch.
> Especially if you use Server.
If of any help I will be upgrading
From maverick to yosemite but its only dev machine with small databases
Sent from my LG Mobile
Craig Ringer wrote:
>On 10/20/2014 08:26 PM, Jerry Levan wrote:
>> I just upgraded one of my Mac computers to Yosemite and am having a
>> small problem.
>
>My preli
I have first to admit the inconsistency is probably on my side!-)
The task - I want to clone a table I created in public schema in another
schema (xxx) of the same database.
The problem - I get an error message when creating the table using the
original SQL script: ERROR: type "geography" does not
Daniel Begin wrote
> I have first to admit the inconsistency is probably on my side!-)
>
> The task - I want to clone a table I created in public schema in another
> schema (xxx) of the same database.
> The problem - I get an error message when creating the table using the
> original SQL script: E
On 10/21/2014 03:33 PM, Daniel Begin wrote:
I have first to admit the inconsistency is probably on my side!-)
The task - I want to clone a table I created in public schema in another
schema (xxx) of the same database.
The problem - I get an error message when creating the table using the
origina
On 10/21/2014 10:49 PM, TigerNassau wrote:
> If of any help I will be upgrading
> From maverick to yosemite but its only dev machine with small databases
Are you using the PostgreSQL bundled by Apple though, or one you
installed yourself?
If you're using the Apple-bundled one, make VERY sure to
On 10/21/2014 5:14 PM, Craig Ringer wrote:
If you're using the Apple-bundled one, make VERY sure to back everything
up carefully with pg_dump before upgrading. Then tell me how it goes.
I'd recommend doing..
$ pg_dumpall --globals-only -f 20141021_globals.sql
$ for db in mydb1 mydb2 ..
Marti Raudsepp Wrote in message:
> Hi
>
> On Tue, Oct 21, 2014 at 12:53 PM, Ilya I. Ashchepkov wrote:
>> I wrote a function and during testing it I came across the strange
>> behaviour.
>> Function runtime is about 200ms first 5 times, 6th and futher calls takes
>> ~22000 ms.
>> I simplified my
Marti Raudsepp writes:
> On Tue, Oct 21, 2014 at 12:53 PM, Ilya I. Ashchepkov wrote:
>> I wrote a function and during testing it I came across the strange
>> behaviour.
>> Function runtime is about 200ms first 5 times, 6th and futher calls takes
>> ~22000 ms.
>> I simplified my schema, you can se
Folks,
I have set about 12GB RAM (shared buffers) for our Postgresql instance. How do
I know if this is actually being used? And is there a way to know by how much
should I increase it, if it is not enough?
Thanks.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To ma
13 matches
Mail list logo
