PG12
RHEL 8
I suspect there's little I can do to get the following query to run
faster/more efficiently but thought I'd post to list and confirm.
Caveat: I'm coming from an Oracle background and am extremely wet behind
ears w/ respect to postgresql (please be kind :)).
Right now, we can't change
disastrous :)
Planning Time: 7.569 ms
Execution Time: 316969.474 ms
On Thu, Apr 16, 2020 at 9:23 AM Pavel Stehule
wrote:
>
>
> čt 16. 4. 2020 v 16:08 odesílatel Chris Stephens
> napsal:
>
>> PG12
>> RHEL 8
>>
>> I suspect there's little I can do
On Thu, Apr 16, 2020 at 10:47 AM Michael Lewis wrote:
> My other thought was to range partition by pixelID + brin index.
>
> I would expect brin index to be INSTEAD of partitioning. You didn't share
> buffer hits, which I expect were 100% on the subsequent explain analyze
> runs, but the
as another Oracle DBA trying to pick up Postgresql one thing i haven't come
across are script libraries such as there are for Oracle (
https://github.com/tanelpoder/tpt-oracle and
https://oracle-base.com/dba/scripts as examples).
Does anything like that exist for PG? Would be nice to see how peopl
posgresql 12
centos 7
i am trying to configure ldap authentication.
i have the following pg_hba.conf entry (server and basedn are correct but
not shown):
hostsslall all 0.0.0.0/0 ldap
ldapserver="ldaps://xxx" ldapbasedn="yyy" ldaptls=1
when i attempt to
!
On Mon, Jun 8, 2020 at 7:41 PM Thomas Munro wrote:
> On Tue, Jun 9, 2020 at 9:05 AM Chris Stephens
> wrote:
> > hostsslall all 0.0.0.0/0 ldap
> ldapserver="ldaps://xxx" ldapbasedn="yyy" ldaptls=1
>
> > does
it looks like there are a number of roles available through ansible galaxy
that support initial postgresql setup and configuration.
i'm wondering if there are any that are more popular/capable that i should
consider vs just picking a few and evaluating those.
does anyone have any recommendations?
posgresql verion: 12
i can accomplish this procedurally fairly easily but would like to do this
strictly in SQL.
jsondb=# select jsonb_typeof(jsonb_path_query(vdl_json,'$.tables[*]')) from
vdl_json2;
jsonb_typeof
--
object
object
object
object
object
object
(6 rows)
jsondb=# s
Hello,
We have a need to display some very simple reports generated from views in
an rds postgres database. We need little more functionality beyond simple
filtering, column hiding, sorting, grouping. Anything much beyond that
would be a strike against the tool.
i'm looking for something similar
I'm trying to create a visual representation of a 6x8 grid of samples on a
rack using the following SQL format:
with rack_display as (
select sr.ts rack_ts
, sr.rack_id
, r.rack_barcode
, 1 as row_pos
, max(case when rack_well = 0 then 'A1: '||sample_barcode end
I'm trying to run pgbouncer but am having trouble with what looks like a
very simple configuration.
centos 7
postgres 12
pgbouncer 1.15
we are already using pam for database auth. pgbouncer was compiled with
--with-pam. there is a /etc/pam.d/pgbouncer config file copied from the one
currently bei
arting up. any
suggestions on how to completely remove and reinstall with support for pam?
On Wed, Apr 28, 2021 at 1:51 AM Laurenz Albe
wrote:
> On Tue, 2021-04-27 at 19:46 -0500, Chris Stephens wrote:
> > I'm trying to run pgbouncer but am having trouble with what looks like
I had to install pam-devel before reinstalling pgbouncer. appears to be
working now. thanks for pointing me in the right direction Laurenz!
On Wed, Apr 28, 2021 at 7:09 AM Chris Stephens
wrote:
> huh. you are right. i originally installed pgbouncer with yum but removed
> with just "
13 matches
Mail list logo
