čt 20. 9. 2018 v 20:29 odesílatel Susan Hurst <
susan.hu...@brookhurstdata.com> napsal:
> Thanks, everyone!
>
> I get it now. It's not just an array but an hstore array. I changed my
> code to include the original values so now it works:
>
> -- new will be substituted for $1 during execution
Well, we are 64-bit I'll see if I can make some kind of self contained
test to repeat it.
Thanks,
Greig
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
Hi
Complex query taken around 30 minutes to execute even i have
increased work_mem value to 4GB temporarily as total ram is 16gb
Explain analyze query taken around 30 minutes to execute even i have
created partial indexes with where condition on required columns
Below is the query plan for
On Fri, Sep 21, 2018 at 7:38 PM Durgamahesh Manne
wrote:
> Hi
>
> Complex query taken around 30 minutes to execute even i have
> increased work_mem value to 4GB temporarily as total ram is 16gb
>
> Explain analyze query taken around 30 minutes to execute even i have
> created partial indexes
Your plan is not readable to me (perhaps because of gmail). Does
https://explain.depesz.com/ give you any useful insights?
On Fri, 21 Sep 2018 at 16:15, Durgamahesh Manne
wrote:
>
>
> On Fri, Sep 21, 2018 at 7:38 PM Durgamahesh Manne
> wrote:
>>
>> Hi
>>
>> Complex query taken around 30 minutes
On 9/21/18 10:35 AM, Mark Williams wrote:
I have PHP v7.2.7 and PostgreSQL v10 with Windows IIS.
I am trying to get this to work following any advice I have been able to
find on the web, but with no success. My configuration so far is as below.
PHP.ini extension list includes both
I have a scenario where a database server need to maintain a huge
number of small databases. So to keep TLS clients connected to this
server is a pain because PG requires to have a unique connection for
each database.
For databases deployed in cloud (like AWS) it is even worse, because
we cannot
> On 21 Sep 2018, at 17:49, Durgamahesh Manne wrote:
>
>
Considering how hard you try to get rid of duplicates, I'm quite convinced that
you're at least short a few join conditions. Getting rid of duplicates early
has the added benefit of having to aggregate fewer rows, which should
On 9/21/18 10:12 AM, Ravi Krishna wrote:
We recently upgraded our JDBC driver to 42.2.5 after seeing this
https://www.postgresql.org/about/news/1883/
All of our PG databases mandates SSL connections. So the first line in
pg_hba.conf is
hostnossl all all all reject
We use dbeaver and while
On 2018-09-21 18:28:37 -0600, Rob Sargent wrote:
> "/tmp/regen.file" gets very large, very fast and I have to
> pg_terminate_backend. Tried this three times, once using "\o test.blob"
> instead.
>
>h009357:loader$ ls -ltr
>total 2048
>-rwxr-xr-x 1 u0138544 camplab 10002460672 Sep 21
Playing around with files-in-text-field. I can happily slam a 10M file
into a text field in a table defined as
gtdb=# \d gt.ld
Table "gt.ld"
Column | Type | Collation | Nullable | Default
--+--+---+--+-
id
On 9/21/18 5:46 PM, Ravi Krishna wrote:
First are doing a socket connection or a host connection? Socket
connections ignore sslmode.
The URL template of JDBC used by dbeaver is
jdbc:postgresql://{host}[:{port}]/[{database}]
From the manual
"The host component is interpreted as described
> On Sep 21, 2018, at 7:59 PM, Andres Freund wrote:
>
>> On 2018-09-21 18:28:37 -0600, Rob Sargent wrote:
>> "/tmp/regen.file" gets very large, very fast and I have to
>> pg_terminate_backend. Tried this three times, once using "\o test.blob"
>> instead.
>>
>> h009357:loader$ ls -ltr
>>
> First are doing a socket connection or a host connection? Socket
> connections ignore sslmode.
The URL template of JDBC used by dbeaver is
jdbc:postgresql://{host}[:{port}]/[{database}]
>From the manual
"The host component is interpreted as described for the parameter host. In
particular,
Just to clarify:
With JDBC 42.1.4 attempt to connect from dbeaver without SSL results in the
following error:
"pg_hba.conf rejected the connection: SSL off"
This is what we expect.
With 42.2.5, the connection succeeds without SSL.
I have PHP v7.2.7 and PostgreSQL v10 with Windows IIS.
I am trying to get this to work following any advice I have been able to
find on the web, but with no success. My configuration so far is as below.
PHP.ini extension list includes both php_pdo_pgsql.dll and php_pgsql.dll.
Both
> i can see a lot of max(string-field) (for instance, LastName,
> MiddleName, FirstName).
> wild guess: completely broken design, but i don't know your application
> and use-case for that.
> again, as i said already, i think this is a case for an in-deep
> consultation.
My thoughts exactly.
We recently upgraded our JDBC driver to 42.2.5 after seeing this
https://www.postgresql.org/about/news/1883/
All of our PG databases mandates SSL connections. So the first line in
pg_hba.conf is
hostnossl all all all reject
We use dbeaver and while setting up connection we check box SSL
Am 21.09.2018 um 17:13 schrieb Durgamahesh Manne:
query is below
query and plan still not readable. Store it into a textfile and attach
it here.
Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com
On Fri, Sep 21, 2018 at 9:12 PM Andreas Kretschmer
wrote:
>
>
> Am 21.09.2018 um 17:13 schrieb Durgamahesh Manne:
> > query is below
>
> query and plan still not readable. Store it into a textfile and attach
> it here.
>
>
> Andreas
>
> --
> 2ndQuadrant - The PostgreSQL Support Company.
>
Am 21.09.2018 um 17:49 schrieb Durgamahesh Manne:
Please find below attached query plan file
query and plan still hard to read :-(
Query:
SELECT distinct
Max(v."vchSubmittersCode") as vchSubmittersCode
, Max(v."vchRecordType") as vchRecordType
, Max(v."vchSequenceNumber") as
21 matches
Mail list logo
