Hello,
While understanding the effect of maintenance_work_mem on time taken
by CREATE INDEX, I observed that for the values of
maintenance_work_mem less than the value for which an internal sort is
performed, the time taken by CREATE INDEX increases as
maintenance_work_increases.
My guess is that
I had just started to wonder if it was something that when you responded. I
checked, and every case that I had where the numbers were wonky checked out
when I subtracted 2^32. Whew!
Thanks, Jeff!
On Jul 22, 2013, at 11:20 AM, Jeff Janes wrote:
> On Fri, Jul 19, 2013 at 3:20 PM, Natalie Wen
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of John R Pierce
> Sent: Monday, July 22, 2013 2:32 PM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Different transaction log for database/schema
>
> On 7
On 7/22/2013 9:33 AM, Ondrej Chaloupka wrote:
thank you for the idea. I didn't know about the function.
Just this probably won't work for my use case. I do not access to
different databases in one transaction. I access different databases
simultaneously each with it's own xa transaction. What I
Hi Sachin,
thank you for the idea. I didn't know about the function.
Just this probably won't work for my use case. I do not access to different
databases in one transaction. I access different databases simultaneously
each with it's own xa transaction. What I understand the switch_xlog servers
On Sun, Jul 21, 2013 at 9:15 PM, Pavel Stehule wrote:
> hello
>
> It can be artefact of RI implementation.
>
> see
> http://michael.otacoo.com/postgresql-2/postgres-9-3-feature-highlight-for-key-share-and-for-no-key-update/
>
> Try to 9.3, please, where RI uses more gently locks
It still behaves
Hi Janek,
Il 21/07/2013 16:46, Janek Sendrowski ha scritto:
Hi,
Im searching for a suitable Index for my query witch compares Strings with the
Levenshtein distance.
I read that a prefix index would fit, but I dont know how to build it. I only
know that its supported by Gist.
I couldn't find
Hello
2013/7/22 Ondrej Chaloupka :
> Hi Sachin,
>
> thank you for the idea. I didn't know about the function.
> Just this probably won't work for my use case. I do not access to different
> databases in one transaction. I access different databases simultaneously
> each with it's own xa transactio
So, in an attempt to see if it was a fluke, I picked one of the date ranges I
was getting a different count for, and deleted the records, and then ran the
insert again. Interestingly, the delete result matched the insert result (which
was the same the second time as it was the first). I'll run a
On Fri, Jul 19, 2013 at 3:20 PM, Natalie Wenz wrote:
> Hi all,
>
> I am moving some data from one table to another in 9.2.4, and keep seeing
> this strange scenario:
>
> insert into newtable select data from oldtable where proc_date >= x and
> proc_date < y;
>
> INSERT 0 78551642
>
> select coun
No triggers, no rules. It's just a very boring, vanilla table. I have had
plenty of cases where the inserts fail because many of the data types are
different in the new table, and there is some junk that fails the cast. And
even though the insert result seems to indicate that it only inserted so
>where I need to run simultaneously different tests using transactions
Are you running tests simultaneously on different databases?
i.e. access to different databases within one transaction.
If not --
after each transaction you can do pg_switch_xlog() then new transaction log
will be created and
Hello,
I would like kindly ask for an advice whether and how the transaction log
behavior could be configured.
I would like to have possibility to differentiate transaction logs for two
databases or schema. I would need such configuration for my testing
environment where I need to run simultan
13 matches
Mail list logo
