> "Alastair" == Alastair McKinley writes:
Alastair> Hi all,
Alastair> I recently experienced a performance degradation in an
Alastair> operational system that I can't explain. I had a function
Alastair> wrapper for a aggregate query that was performing well using
Alastair> the expected
On 5/18/19 5:39 PM, Peter J. Holzer wrote:
On 2019-05-18 17:14:59 -0500, Ron wrote:
On 5/18/19 3:49 PM, Peter J. Holzer wrote:
On 2019-05-18 15:19:22 -0500, Ron wrote:
On 5/18/19 2:27 PM, Peter J. Holzer wrote:
On 2019-05-18 10:49:53 -0700, David G. Johnston wrote:
On 2019-05-18 17:14:59 -0500, Ron wrote:
> On 5/18/19 3:49 PM, Peter J. Holzer wrote:
>
> On 2019-05-18 15:19:22 -0500, Ron wrote:
>
> On 5/18/19 2:27 PM, Peter J. Holzer wrote:
>
> On 2019-05-18 10:49:53 -0700, David G. Johnston wrote:
>
> You don’t perf
Jeremy Schneider - Thanks for that psqlrc file. Pretty informative. :-)
On Wed, May 8, 2019 at 11:55 AM Jeremy Schneider
wrote:
> On 5/6/19 23:27, Rashmi V Bharadwaj wrote:
> > Is there a SQL query or a database parameter setting that I can use from
> > an external application to determine if t
On 5/18/19 3:49 PM, Peter J. Holzer wrote:
On 2019-05-18 15:19:22 -0500, Ron wrote:
On 5/18/19 2:27 PM, Peter J. Holzer wrote:
On 2019-05-18 10:49:53 -0700, David G. Johnston wrote:
You don’t perform math on a hash
That's not generally true. Hashes are used for further computation for
example
On 2019-05-18 15:19:22 -0500, Ron wrote:
> On 5/18/19 2:27 PM, Peter J. Holzer wrote:
> > On 2019-05-18 10:49:53 -0700, David G. Johnston wrote:
> > > You don’t perform math on a hash
> > That's not generally true. Hashes are used for further computation for
> > example in hash tables or in cryptog
On 5/18/19 2:27 PM, Peter J. Holzer wrote:
On 2019-05-18 10:49:53 -0700, David G. Johnston wrote:
On Saturday, May 18, 2019, Peter J. Holzer wrote:
On 2019-05-16 08:48:51 -0700, David G. Johnston wrote:
> On Thu, May 16, 2019 at 8:31 AM Daulat Ram
wrote:
>
>
>
On 2019-05-18 10:49:53 -0700, David G. Johnston wrote:
> On Saturday, May 18, 2019, Peter J. Holzer wrote:
>
> On 2019-05-16 08:48:51 -0700, David G. Johnston wrote:
> > On Thu, May 16, 2019 at 8:31 AM Daulat Ram
> wrote:
> >
> >
> > url_hash | bigint
Will Hartung writes:
> I am trying to load data in to a table with a jsonb field that is indexed
> as gin (field jsonb_path_ops).
> ...
> The current file is "stuck", pushing past 20hrs so far.
In addition to the questions about what PG version you're using, is
the backend process that's doing th
On Saturday, May 18, 2019, Peter J. Holzer wrote:
> On 2019-05-16 08:48:51 -0700, David G. Johnston wrote:
> > On Thu, May 16, 2019 at 8:31 AM Daulat Ram
> wrote:
> >
> >
> > url_hash| bigint | | not null |
> >
> >
> > Change the type of url_hash; make it t
On 5/17/19 12:10 PM, Will Hartung wrote:
I am trying to load data in to a table with a jsonb field that is
indexed as gin (field jsonb_path_ops).
In addition to what Tim asked:
Is the jsonb field the only field in the table?
Can we see the table schema?
--
Adrian Klaver
adrian.kla...@ak
On 5/18/19 4:17 AM, Alastair McKinley wrote:
Hi all,
I recently experienced a performance degradation in an operational
system that I can't explain. I had a function wrapper for a aggregate
query that was performing well using the expected indexes with the
approximate structure as shown belo
Hi all,
I recently experienced a performance degradation in an operational system that
I can't explain. I had a function wrapper for a aggregate query that was
performing well using the expected indexes with the approximate structure as
shown below.
create or replace function example_function
On 2019-05-16 08:48:51 -0700, David G. Johnston wrote:
> On Thu, May 16, 2019 at 8:31 AM Daulat Ram wrote:
>
>
> url_hash | bigint | | not null |
>
>
> Change the type of url_hash; make it text instead of bigint.
Or numeric(38, 0). I think it isn't coinci
14 matches
Mail list logo
