On 09/23/2018 10:21 PM, Arup Rakshit wrote:
> Hello I have some questions related to the query plan output about the
> planned and actual rows. In the following example:
>
> # explain (analyze true, costs true, format yaml) select * from users
> where lower(city) = 'melanyfort' and lower(state)
On 09/22/2018 06:00 AM, Andreas Kretschmer wrote:
Am 22.09.2018 um 02:28 schrieb Rob Sargent:
However, I get into deep dodo when I try redirecting psql output such as
select ld from gt.ld\g /tmp/regen.file
works for me if i start psql with -t -A -o /path/to/file
(pg 10.5, but psql f
Hello I have some questions related to the query plan output about the planned
and actual rows. In the following example:
# explain (analyze true, costs true, format yaml) select * from users where
lower(city) = 'melanyfort' and lower(state) = 'ohio';
On 9/23/18 3:54 AM, Mark Williams wrote:
Thanks for the suggestions.
I don't think there is any dependencies in the lib folder, but added it anyway
and it made no difference.
I tried "Process Explorer" (having previously tried "Dependency Walker") PE
revealed one or two more dependencies I wa
On Sun, Sep 23, 2018 at 1:15 PM Kim Rose Carlsen wrote:
> Hi
>
>
> I have some simple INSERT / UPDATE queries, that takes a long time the
> first time they are run in out test environment, but I'm not sure what
> postgres is doing and what I can do to help it. Whats common is that the
> table con
Hi
I have some simple INSERT / UPDATE queries, that takes a long time the first
time they are run in out test environment, but I'm not sure what postgres is
doing and what I can do to help it. Whats common is that the table contains
many rows in the order of about 20 millions.
Query:
INSERT
On Sat, Sep 22, 2018 at 04:58:18PM +0200, Christoph Moench-Tegeder wrote:
> ## Doron Behar (doron.be...@gmail.com):
>
> > My server fails to start PostgreSQL only on boot, if I restart it
> > manually afterwards it doesn't have any problem starting. Here is the
> > log extracted from the journal:
Thanks for the suggestions.
I don't think there is any dependencies in the lib folder, but added it anyway
and it made no difference.
I tried "Process Explorer" (having previously tried "Dependency Walker") PE
revealed one or two more dependencies I was previously unaware of. Added these
to th
On Sat, Sep 22, 2018 at 07:14:33AM -0700, Adrian Klaver wrote:
>
> Linux distro and version?
Arch Linux
$ uname -a
Linux vps 4.18.9-arch1-1-ARCH #1 SMP PREEMPT Wed Sep 19 21:19:17 UTC
2018 x86_64 GNU/Linux
It's a VPS with one CPU core on it and 2G RAM - not very much I know,
ho
