On 30/04/13 14:49, Igor Neyman wrote:
>
>> -Original Message-
>> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
>> ow...@postgresql.org] On Behalf Of Igor Neyman
>> Sent: Tuesday, April 30, 2013 9:30 AM
>> To: Lutz Fischer; pgsql-general@
On 30/04/13 11:58, Lutz Fischer wrote:
> On 29/04/13 19:09, Igor Neyman wrote:
>>> -Original Message-
>>> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
>>> ow...@postgresql.org] On Behalf Of Lutz Fischer
>>> Sent: Monday, April
On 29/04/13 19:09, Igor Neyman wrote:
>
>> -Original Message-
>> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
>> ow...@postgresql.org] On Behalf Of Lutz Fischer
>> Sent: Monday, April 29, 2013 1:52 PM
>> To: pgsql-general@postgresql.
ulls.
>
> or, try putting EACH where condition enclosed in
> its own ( ) set.
>
>
> On Mon, Apr 29, 2013 at 12:52 PM, Lutz Fischer
> mailto:lfisc...@staffmail.ed.ac.uk>> wrote:
>
> Hi,
>
> had a bit of weird result for a query:
> SEL
py of the database and run it
under Linux (Debian wheezy).
There the first query returned 136k lines and this id was the first
difference.
Does anybody has an idea what is going on?
It's postgresql 9.2.1 running under a windows 2008 R2 server
Lutz
--
Lutz Fischer
lfisc...@staffmail.ed.ac.
the given time there were no concurrent access to any of the
involved tables.
Has anybody some idea why the insert takes so long and/or how to speed
things up a bit? I could live with something like half an hour - better
would be in minutes.
Thanks for any responds,
Lutz Fischer
--
The
