Re: Working around, or with, bitmap heap scan?

Thank you. Do you need the entire output of 'EXPLAIN (ANALYZE, BUFFERS) ...', or will just the sub-section, as I emailed for the plain 'EXPLAIN ...' I initially e-mailed. do?

Re: Working around, or with, bitmap heap scan?

Well, so as to not spam the list here's a link to a folder with copies of the output: https://drive.google.com/open?id=1lSlx7UMUMNgRft2B3Rq2zc4WIRJLLOqU On Fri, Nov 2, 2018 at 4:12 AM James A. Robinson wrote: > > Thank you. Do you need the entire output of 'EXPLAIN (ANALYZE, >

Re: Working around, or with, bitmap heap scan?

On Fri, Nov 2, 2018 at 6:21 AM Laurenz Albe wrote: > I have no idea how to improve that, sorry. Heh, thank you for looking. From your response I've got a vision of a medical drama where the doctor looks over some test results and sadly informs the patient "I'm sorry, there

How to setup only one connection for the whole event loop?

Dear all, I am new to postgresql and I am creating a c program that can receive request from different users. I want to maximize the performance of postgresql so I intend to just create 1 connection that would service all queries of different users. How do I do this? Do I create a new

Re: Postgresql range_agg() Return empty list

ower(bin_range)+1, upper(bin_range)+5) as r > From bin_data) as b; > The value '(,)' signifies a range with no lower bound and no upper bound. So '{(,)}' is the multirange that contains just that range (unbounded in either direction)---in other words not an empty list but ev

Temporal Foreign Keys

Since there have been a couple threads on the hackers list about temporal features [1, 2], I thought I'd share an extension I've been writing for temporal foreign keys: https://github.com/pjungwir/time_for_keys There is a big test suite, but right now it is still basically a proof-

RES: Supartitions in PGSQL 10

> Kumar, Virendra schrieb am 08.01.2018 um 22:12: > > Can you please let us know if Sub-partitions are supported in PGSQL > > (declarative partitions) 10.1. If yes can it be list-list partitions. > > We have a situation where a table is very big having around 2 billion > &

help with generation_series in pg10

4 5 | 5 6 | 7 | 8 | 9 | 10 | (10 registros) how can i have the same in pg10 as i have had in pg 9.x? I need it to date type to... if possible. -- Att. Márcio A. Sepp

RES: help with generation_series in pg10

> > how can i have the same in pg10 as i have had in pg 9.x? > > Move the function call to the FROM clause: > > select g, (g - 1) % 5 + 1 from generate_series(1, 10) g; thank you. That is exact what i need. > > I need it to date type to... if possible. > &

RES: help with generation_series in pg10

ed. > > > > > >> > I need it to date type to... if possible. > >> > >> There is a generate_series() variant that can return dates (more > >> precisely, timestamp with time zone). But what exactly would you > >> like returned? > > > >

Re: Using AWS ephemeral SSD storage for production database workload?

> I have come across some ideas on the Internet > where people hinted at running production PostgreSQL workloads > on AWS ephemeral SSD storage. I think people were more serious about that before AWS introduced PIOPS. I wouldn't do this unless I had streaming replication to a

Question about different behaviour in pg_wal when archive_mode is set on or off

Hi, I'm trying to understand the relation between 'archive_mode', pg_wal directory, 'max_wal_size' and failover. I'm running the kubernetes example from patroni (patroni 4.0.6) When 'archive_mode: off', and I issue a couple of 'patronictl failover&#x

Need details on 9.6 version of postgres

Hi, I am using Jboss EAP 6.1 version. For Database i am using the postgres 9.3 version. Can i upgrade to postgres 9.6 without any issue. I am also considering to implement BDR 2.0, please let me know how i can get the licensing details. -- with regards A H S Phanindra

Determine which Row Level Security policies were denied

Hi! Is it possible to determine which RLS policies failed on INSERT OR UPDATE? For instance, this is the error returned when inserting a new record: **ERROR: new row violates row-level security policy for table "my_table"** Is it possible to obtain the name of the policy(ies) that

<    1   2