Hi Alex,
On Sat, 18 Jan 2025 at 12:21, Alexander Farber
wrote:
> [...]
>
> -- Run 2 smoke tests
> DO $$
> DECLARE
> test_result RECORD;
> BEGIN
> -- Test 1: store 15x4 records expiring in 5 seconds
> SELECT * INTO test_result FROM test_store_vehicle_data(15);
> IF test_result.co
Hi Ram,
29 set 2024, 12:29 Ramakrishna m :
*We are planning to set up logical replication from a standby to another
> server. When the primary goes down, there is no issue as the standby
> becomes the primary and the logical slots are already present. However,
> when the standby goes down, these
On Fri, 9 Aug 2024 at 06:20, Ron Johnson wrote:
>
> What if the partitions aren't all rationally named? There *must* be a
> pg_* table out there which contains the partition boundaries...
>
>
The pg_class column relpartbound contains an internal representation of the
partition boundary, when app
On Thu, 17 Aug 2023 at 19:09, GF wrote:
>
> Erik,
> The could be a possible solution, if you could play with search_path...
>
>
(sorry, Erik, obviously my message was intended to Markus)
Erik,
The could be a possible solution, if you could play with search_path...
You could mirror all the original schema onto another one with views that
have the original table names.
For all tables that need some special treatment you can then write
instead-of triggers, while all other views are up
On Fri, 12 May 2023 at 13:04, Durumdara wrote:
> Dear Members!
>
> I have a table with temperature measures.
> The data is coming from the PLC, but sometimes the period is "slipping",
> so the values are not correctly minute based.
>
> 03:00 10
> 03:02 12
> 03:03 11
> 03:05 13
>
>
Markus,
Yesterday EDB published the (open source) pg_failover_slots extension,
aimed at pushing logical slot information on standbys: without it, that
information is kept on the master only, so you have to rebuild the logical
replication topology on switch/fail-overs.
Obviously, if the promoted ser
For membership/equality predicates (also partial, for multiple columns) you
could take a look at bloom indexes: they are quite efficient in terms of
space footprint, you can even choose how long is the signature for each
entry and how is distributed among the columns.
https://www.postgresql.org/doc
