Emacs, but also to write SQL queries in a buffer
and then send the whole buffer or the region.
It's not documented in the info pages, but from within Emacs, one of
these should get you started:
C-h P sql
M-x sql-help
Or just do: M-x sql-postgres
- Ben
available by
the PostgreSQL project? It appears so, but I'd like ensure my purchase
goes toward supporting the project in some small way.
Also, is anyone aware whether these printed manuals are available from
any other booksellers online?
Thanks,
- Ben
ing or fetching the HTML
locally may also work. In terminal environment, I suppose one could use
`lynx` or similar to navigate around.
- Ben
convenient to view the the manual for the version of Postgres that is on
the system, right there. Does one exist?
--
Ben Hancock
On Thu, 27 Jul 2023 06:09:28 -0700
"David G. Johnston" wrote:
> On Thursday, July 27, 2023, Ben Hancock wrote:
> >
> >
> > Should the CREATEDB privilege be inherited when granting the 'admins'
> > role to a user, or is another step required?
&
ser, or is another step required?
Or (quite possibly) have I misunderstood something else?
Many thanks,
Ben Hancock
PostgreSQL 14.3
Rita wrote on 7/8/23 4:27 AM:
I am not sure if it allows transaction pooling.
Well, take the time to figure it out. With transaction pooling enabled,
you can get away with a much lower number of server connections. For
example, our application regularly has thousands of clients connected to
Rita wrote on 7/7/23 9:23 AM:
I have an application that does many db calls from a server farm.
I've increased my max connections on postgresql to 1000 and tuned the
server accordingly. However, I still get can't connect to postgresql
some times. I installed pgbouncer on few servers in the fa
Laurenz Albe wrote on 6/28/23 5:27 AM:
On Wed, 2023-06-28 at 07:19 -0400, Rita wrote:
seems like I may need to deploy pgbouncer for my webapp. should i deploy it on
the db server or on the webserver?
On the database server. You don't want network latency between pgbouncer and
PostgreSQL,
so
Jeremy Schneider wrote on 6/27/23 11:47 AM:
Thank Ben, not a concern but I'm trying to better understand how common
this might be. And I think sharing general statistics about how people
use PostgreSQL is a great help to the developers who build and maintain it.
One really nice thing
We certainly have databases where far more than 100 tables are updated
within a 10 second period. Is there a specific concern you have?
Jeremy Schneider wrote on 6/27/23 9:01 AM:
Question for other PostgreSQL users
On your moderately busy DB, how many different tables might receive at
least o
Mohsin Kazmi wrote on 6/9/23 3:38 AM:
Now in order to deploy PostgreSQL in our production servers, I need to
configure it in Active Active mode. Can anyone help me to do so?
We don't need multi-master postgres very often, but when we do, we find
the open source bucardo project works fairly wel
Inzamam Shafiq wrote on 3/24/23 4:07 AM:
Hi Team,
Hope you are doing well.
Can someone please list pros and cons of MariaDB vs PostgreSQL that
actually needs serious consideration while choosing the right database
for large OLTP DBs (Terabytes)?
That's a very broad question, which will take
thing like
this:
SELECT country
, count(*) AS ct_cities
, max(population) AS highest_population
, last(city ORDER BY population, city) AS biggest_city -- !FROM
citiesGROUP BY countryHAVING count(*) > 1;
-Ben
On Mon, Mar 6, 2023 at 9:51 PM David Rowley wrote:
> On Tue, 7 M
>
(https://dba.stackexchange.com/a/324646/100880)
GitHub: https://github.com/wulczer/first_last_agg
Reason: As a non-dba, I can’t install additional modules like first_last_agg
.
Thanks,
-Ben
- DBA Stack Exchange - PostgreSQL equivalent to Oracle's MAX(...) KEEP
(DENSE_RANK FIRST/LAST ORDER BY ...)
<https://dba.stackexchange.com/a/324429/100880>
Thanks,
-Ben
Thank you all for your responses!
I will continue to put pressure on the vendor (Stitch Data, if anyone knows
folks there) to address the issue on their end with the query being issued.
Best,
Ben Chrobot
On Tue, Feb 14, 2023 at 11:11 PM Tom Lane wrote:
> David Rowley writes:
> > O
8.325 rows=5 loops=1)
Index Cond: ((id > 193208795) AND (id <= 575187488))
Planning Time: 0.166 ms
Execution Time: 402.376 ms
We have tried leading the planner to water with this view but it did not
change the slow query plan:
create view my_fast_large_table as
select *
from my_large_table
where id is not null;
Any other tricks to try here?
Thank you,
Ben Chrobot
Sascha Zenglein wrote on 11/2/22 7:56 AM:
Hi all,
I want to use the postgres-native logical replication to have multiple
clients receive and send data to a central database.
Real-time is far less important than network usage, and with my
current test setup it appears both instances communicate
Michael Paquier wrote on 1/26/22 9:14 PM:
On Wed, Jan 26, 2022 at 05:30:01PM -0800, Ben Chobot wrote:
Other things we've considered:
- we run pg_repack, which certainly seems like it could make an error
like this, but we see this error in places and times that pg_repack isn't
We do a lot of queries per day, over a lot of hosts, all of which are on
12.9. We've recently started doing a better job at analyzing our db logs
and have found that, a few times a day, every day, we see some of our
queries fail with errors like:
could not open relation with OID 201940279
In
Hello pgsql-general,
I've been tasked with scanning our Ubuntu-hosted databases for NIST
800-53v4 compliance. I'm finding a paucity of tools out there that will
do this. I found a few that might work, when pointed at Postgres 9 on
RHEL, but not much else.
Is this a problem anybody else has t
Mladen Gogala wrote on 11/30/21 7:52 PM:
To my knowledge PostgreSQL doesn't support sharding, which is well and
good because sharding is mostly useless, at least in my opinion.
OK I'll bite.
Not only does PostgreSQL natively support table partitioning (which is
absolutely a form of shardin
Saurav Sarkar wrote on 11/30/21 7:08 PM:
So are all the schemas on one DB or are distributed/sharded across
multiple DBs ?
In our use case, every db entirely homes one or more schemas. Some dbs
host many schemas for small customers, some dbs host a handful of
schemas for medium customers, and s
Saurav Sarkar wrote on 11/29/21 10:13 PM:
Hi All,
We have some multi-tenant solutions which are separating the tenant
data in Postgresql mainly in the following manner.
1. Using different schemas
2. Using different tables for different tenants.
Without more details it's impossible to give y
Rita wrote on 11/10/21 5:36 PM:
Yes, I have read the manual and seen this. It pauses the replication
(select pg_is_wal_replay_paused()). But on the primary, when I look at
pg_stat_replication, it still says 'streaming' in the state column. My
question was how do I get it from 'streaming' to an
Rita wrote on 11/10/21 1:25 PM:
Hello.
I am testing alerting on my primary and standby setup. I have async
replication working but I would like to temporarily pause it so the
value of 'state' isn't streaming. (select * from pg_stat_replication).
How can I do that?
By reading the fine manua
Two thoughts:
1. Can the user view the tables when connecting through another database
program (ie psql or PgAdmin)?
2. Does the user have access to the database schema that has the PostGIS
extension (normally public schema)?
cheers
Ben
On Thu, 14 Oct 2021 at 19:00, celati Laurent
wrote
On Fri, Oct 8, 2021 at 4:33 PM Francisco Olarte
wrote:
> If you do not run the same sequences, you do not know. Note I do not
> know what exact sequences you have tested, I write with only what I
> have read as as input.
>
I ran this on both versions on fresh instances / clusters with the data
f
Hi, thanks for the answer.
I ran the same scipt on both sides at first.
Then I switched to a COPY because the CREATE TABLE generates random data.
Since I got weird results, I wanted to be sure I had the same data on both
versions.
I ran the tests several times (and even asked a collegue to do it
Hi,
I am playing around with the gist fast build and comparing the result
between v13 and v14.
The space gain and speed increase are really awesome.
When I compare the performance with the following script, I get a lot more
data read into the buffers in v14 and a little slower query.
Is it expec
er).
TITLE=WFS
1: BOMEC_15_Class_WFS:BOMEC_15_Class (title: BOMEC_15_Class) (Multi Surface)
not very helpful, but a 400 error might be some kind of encoding problem
with request?
cheers
Ben
On Tue, 5 Oct 2021 at 14:18, Brent Wood wrote:
> Hi,
>
> Apologies, this not strictly a Postgre
Thomas Munro wrote on 9/14/21 5:50 PM:
On Tue, Sep 14, 2021 at 10:11 AM Ben Chobot wrote:
We've noticed that the Ubuntu postgresql-12 package has --with-llvm
enabled on x86_64, but not on aarch64. Does anybody know if this was
intentional, or just an oversight?
For what it's worth
We've noticed that the Ubuntu postgresql-12 package has --with-llvm
enabled on x86_64, but not on aarch64. Does anybody know if this was
intentional, or just an oversight?
For what it's worth, it seems the beta postgresql-14 package for Ubuntu
still doesn't have --with-llvm.
I'm not sure if
Bryan Boone wrote on 8/18/21 11:39 AM:
Can someone tell me if I am able to use PostgreSQL for the small
company I work for?
Yes, you are.
27; | psql new_database
this is presuming a space before the schemaname, and a fullstop between
schema and other elements.
cheers
Ben
On Sat, 24 Jul 2021 at 01:38, Mayan wrote:
> Hi,
>
>
>
> I had a general question about a feature that we depended on heavily when
> using other R
hubert depesz lubaczewski wrote on 7/15/21 5:15 AM:
select * from regexp_matches(_YOUR_MULTIRANGE_::text, '[\[(][^\])]+[\])]', 'g');
I wrote more, including explanation, and ready-to-use function, in here:
https://www.depesz.com/2021/07/15/how-to-get-list-of-elements-from-multiranges/
So ugly
I'm really, really liking the multirange types in PG14. Thank you for
making them! Unfortunately I am struggling with how to loop over the
segments of a multirange. There doesn't seem to be a way to convert them
to arrays, and I can't just use plpgsql's FOREACH on one. Am I missing
something ob
Rama Krishnan wrote on 7/3/21 8:35 AM:
Hi Team,
How can I split read and write queries using pgbouncer
You do it with your application. Make a pgbouncer database for
read/write queries and point it at your postgresql primary, and then
make a second pgbouncer database for read-only queries a
Your connection string will work as long as there is a DNS entry for
PGServer.
Your pg_hba.conf will however need to have an IP address/netmask. So if you
are connecting from within your local network, you can put something like:
hostssl all all 192.168.0.0/16 md5
Hth?
On W
s is useful for someone else. Thanks again for your help
Tom - your advice on listen/notify locking on commit was very useful
despite not being the cause in this case.
Cheers
Ben
On Mon, 1 Feb 2021 at 12:33, Ben Hoskings wrote:
>
> On Mon, 1 Feb 2021 at 10:33, Tom Lane wrote:
> &
he build script still failed at
the same point showing the same error citing the readline/history.h from
the apple SDK's... is there something else I have to do to ensure it uses
the ones on the PATH and specified in the configure?
cheers
Ben
On Mon, 1 Mar 2021 at 12:50, Tom Lane wrote:
x27;m not sure that rl_set_screen_size is a good replacement for reset, and I
realise that this might be about the apple readline libs... do I need to
install another version of readline, or is there somewhere else I should be
looking? )and can I assume given the proximity of the second error, that it
(grasping at straws here...)
> wraparound of the file names back to ?
We don't have filesystem access on Cloud SQL - the downside of the
managed route :)
It sounds like it might be time to bump the pg13 upgrade up the TODO list.
Cheers
Ben
unless we can convince Google to run it for
us :)
I wonder if there are any likely candidates that we could look into -
for example, is it possible it could be due a batched index update
that we could alleviate with "fastupdate=off"?
Cheers
Ben
messages on commit:
https://www.postgresql.org/message-id/3598.1363354686%40sss.pgh.pa.us
If that's the case, the real question is why a small number of those
commits are taking so much longer than expected. Any advice on how to
proceed from here much appreciated.
Cheers
Ben Hoskings
---
The observed outage
Hi,
I am testing things on hash aggregate spilling in version 13.1 and am
struggling to understand the partition thing in the two explains below.
My understanding is that a partition corresponds to a spill file which will
be treated in a later batch (which can re-spill in some cases).
Am I right
20-07-01 13:22:58+08 | 2020-07-01 | D | 5 | S00 | F02 | {PDCB}
(5 rows)
)
The result in returned column looks different but
definition of the column in question (wspan::float8) looks identical in
both case.
Regards,
Ben
On 9/17/20 10:41 PM, Jerry Sievers wrote:
Ben writes
cern is that if there are other views inside that database having similar
integrity issue, how can I find them all (if any).
It's beyond my regular SQL ability. I guess I really need help from people with
maintenance experience.
Any help will be appreciated, thanks in advance.
Ben
On Sep
intended to show just a small set of
them.
But you are right, I should be more cautious. Thanks for the headsup.
Regards,
Ben
On 9/16/20 3:35 PM, Magnus Hagander wrote:
On Wed, Sep 16, 2020 at 9:26 AM Ben <mailto:benten...@outlook.com>> wrote:
Dear list,
Recently I am getting
tats_per_shift_filtered definition is a different object from
utlog.stats_per_shift_filtered_u0206?
I am totally out of clues. Any help would be appreciated. Thanks.
Regards,
Ben
Alvaro Herrera wrote on 8/3/20 4:54 PM:
On 2020-Aug-03, Ben Chobot wrote:
Alvaro Herrera wrote on 8/3/20 2:34 PM:
On 2020-Aug-03, Ben Chobot wrote:
dd if=16605/16613/60529051 bs=8192 count=1 seek=6501 of=/tmp/page.6501
If I use skip instead of seek
Argh, yes, I did correct that in my
Thanks Tom and Adrian,
The clarity is helpful - We'll run up a solution to specifically choose the
elements.
cheers
Ben
On Sat, 15 Aug 2020 at 00:45, Tom Lane wrote:
> Ben Madin writes:
> > " Is the index number ( the archive ID) assigned at the time of creation
> &g
pt to grep the lines
we need out of the list of the current dump, not re-use the same list file?
cheers
Ben
--
[image: Ausvet Logo] <https://www.ausvet.com.au/>
Dr Ben Madin
BVMS MVPHMgmt PhD MANZCVS GAICD
Managing Director
Mobile:
+61 448 887 220 <+61448887220>
E-mail:
b...
Alvaro Herrera wrote on 8/3/20 2:34 PM:
On 2020-Aug-03, Ben Chobot wrote:
Alvaro Herrera wrote on 8/3/20 12:34 PM:
On 2020-Aug-03, Ben Chobot wrote:
Yep. Looking at the ones in block 6501,
rmgr: Btree len (rec/tot): 72/ 72, tx: 76393394, lsn:
A0A/AB2C43D0, prev A0A/AB2C4378
/page.6501
Ben might find this approach to dumping out a single page image
easier, since it doesn't involve relfilenodes or filesystem files:
https://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD#contrib.2Fpageinspect_page_dump
I don't think th
Alvaro Herrera wrote on 8/1/20 9:35 AM:
On 2020-Aug-01, Ben Chobot wrote:
Can you find out what the index is being modified by those LSNs --
is it
always the same index? Can you have a look at nearby WAL records that
touch the same page of the same index in each case?
They turn out to be
Peter Geoghegan wrote on 8/3/20 11:25 AM:
On Sun, Aug 2, 2020 at 9:39 PM Kyotaro Horiguchi
wrote:
All of the cited log lines seem suggesting relation with deleted btree
page items. As a possibility I can guess, that can happen if the pages
were flushed out during a vacuum after the last checkpo
Alvaro Herrera wrote on 8/3/20 12:34 PM:
On 2020-Aug-03, Ben Chobot wrote:
Yep. Looking at the ones in block 6501,
rmgr: Btree len (rec/tot): 72/ 72, tx: 76393394, lsn:
A0A/AB2C43D0, prev A0A/AB2C4378, desc: INSERT_LEAF off 41, blkref #0: rel
16605/16613/60529051 blk 6501
rmgr
Ben Chobot wrote on 8/1/20 9:58 AM:
Alvaro Herrera wrote on 8/1/20 9:35 AM:
On 2020-Aug-01, Ben Chobot wrote:
Can you find out what the index is being modified by those LSNs -- is it
always the same index? Can you have a look at nearby WAL records that
touch the same page of the same index in
Kyotaro Horiguchi wrote on 8/2/20 9:39 PM:
At Sat, 1 Aug 2020 09:58:05 -0700, Ben Chobot wrote in
All of the cited log lines seem suggesting relation with deleted btree
page items. As a possibility I can guess, that can happen if the pages
were flushed out during a vacuum after the last
Alvaro Herrera wrote on 8/1/20 9:35 AM:
On 2020-Aug-01, Ben Chobot wrote:
We have a few hundred postgres servers in AWS EC2, all of which do streaming
replication to at least two replicas. As we've transitioned our fleet to
from 9.5 to 12.3, we've noticed an alarming incre
We have a few hundred postgres servers in AWS EC2, all of which do
streaming replication to at least two replicas. As we've transitioned
our fleet to from 9.5 to 12.3, we've noticed an alarming increase in the
frequency of a streaming replica dying during replay. Postgres will log
something lik
gt; $BODY$ language sql immutable;
>
> but if string contains % character,
>
> select val('1,2%')
>
> returns 0.
>
> How to force it to return 1.2 ?
>
> It should work starting from Postgres 9.0
>
> Posted also in
>
>
> https://stackoverfl
Igor Polishchuk wrote on 5/30/20 9:33 PM:
Hello,
I need to replicate Postgresql 9.6 to AWS RDS Postgresql 12.2 with
pg_logical.
AWS RDS Pg 12.2 (target) only supports pg_logical 2.3.0.
Can I use v2.3.1 on the source and v2.3.0 on the target?
We had lots of issues with pglogical when we accid
We have a few busy 9.5 dbs, both streaming to a few slaves each. The
master and slaves are identical hardware and are getting no small amount
of load - about 45k transactions/s on the master and ~36k transactions/s
on the slave actively serving clients. During these busy times, queries
are all
ts ;-)
>
> regards, tom lane
>
>
>
--
[image: Ausvet Logo] <https://www.ausvet.com.au/>
Dr Ben Madin
BVMS MVPHMgmt PhD MANZCVS GAICD
Managing Director
Mobile:
+61 448 887 220 <+61448887220>
E-mail:
b...@ausvet.com.au
Website:
www.ausvet.com.au
Skype: benmadin
Address:
5 Shuffrey Street
Fremantle, WA 6160
Australia
Hi All,
What is your backup and restore solution in production when working with
Postgres ?
(+ if you can say few words why you picked this X solution instead of others)
Regards,
Dor
This email and the information contained herein is proprietary and confidential
and subject to the Amdocs Email
Hi All,
What Is the best recommended / used tool for backup and restore that you
suggest or work with postgres ?
Regards,
Dor
This email and the information contained herein is proprietary and confidential
and subject to the Amdocs Email Terms of Service, which you may review at
https://www.amdo
Hi,
What is the most common used back and restore solution for postgres ?
Which one are you using ?
Regards,
Dor
This email and the information contained herein is proprietary and confidential
and subject to the Amdocs Email Terms of Service, which you may review at
https://www.amdocs.com/abou
Hi Zwettler,
Based on what comparison, production experience ?
Regards,
Dor
From: Zwettler Markus (OIZ)
Sent: Monday, December 9, 2019 1:13 PM
To: Dor Ben Dov ; pgsql-general@lists.postgresql.org
Subject: AW: PostgreSQL HA FO question
In my opinion, the best open source product is Patroni
Hi everyone,
What is the best / mostly common / production used open source solution for HA
/ FO/ backup and restore.
Open source community / Commercial
Best Regards,
Dor Ben Dov
This email and the information contained herein is proprietary and confidential
and subject to the Amdocs Email
On Sep 29, 2019, at 8:44 PM, Ron wrote:
>
> On 9/29/19 8:09 PM, Steve Litt wrote:
>> On Mon, 30 Sep 2019 07:46:14 +1000
>> Nathan Woodrow wrote:
>>
>>> Redis is a in memory database so I would except it to be always much
>>> faster..
>> Is there a way to have Redis periodically update an on-dis
ppened or how I can fix this issue?
I had the issue once on another server and running VACUUM FULL on entire
database fixed the error.
Note: I ran "VACUUM FREEZE ANALYZE" before the upgrade on every database
and there were no errors.
Ben Snaidero
*Geotab*
Senior Database Specialist
s a zero-length record? (this does seem to mitigate the error - see
attached patch)
Thanks,
Ben
0001-Fix-pg_rewind-when-divergence-is-at-end-of-WAL.patch
Description: Binary data
On Sep 5, 2019, at 2:00 PM, Judith Lacoste wrote:
>
> Hi,
>
> I plan to install the database on a server in the office. Me and my four
> colleagues will occasionally connect to this database when we are working in
> other locations (usually hospitals or universities). In such remote
> locatio
On Thu, Jun 27, 2019 at 3:19 PM Tom Lane wrote:
> Ben Snaidero writes:
> > Do these stack traces shed help at all?
>
> None worth mentioning :-(. Can you rebuild with debug symbols?
>
> regards, tom lane
>
So I've rebuilt with debug sym
On Thu, Jun 27, 2019 at 2:34 PM Tom Lane wrote:
> Ben Snaidero writes:
> > I am running into a strange issue with Postgres 10 when using pg_dump
> with
> > the directory format and jobs parameter set it intermittently hangs.
> Seems
> > to occur less frequent
PostmasterMain+0x275
postgres.exe!main+0x480
postgres.exe!pgwin32_popen+0x144f
KERNEL32.DLL!BaseThreadInitThunk+0x14
ntdll.dll!RtlUserThreadStart+0x21
Any ideas on changes in Postgres 10 that would cause this? We were
previously running 9.6.7 and didn't encounter this issue on that version
either.
where multiple partitions are detached in 1
statement.
This is using version 12 beta 1.
Many thanks,
Ben
Or you can just use `ilike`:
SELECT * FROM emp WHERE ename ilike 'aaa';
https://www.postgresql.org/docs/10/sql-select.html#SQL-WHERE
cheers
Ben
On Thu, 28 Mar 2019 at 16:24, Sameer Kumar wrote:
>
>
> On Thu, 28 Mar, 2019, 4:20 PM Sridhar N Bamandlapally, <
> sri
> On Mar 6, 2019, at 5:58 AM, Nanda Kumar
> wrote:
>
> Hello Team,
>
> I would like to know where I can monitor the ddl and dml operations happens
> in the production environment .
The documentation is your friend, particularly
https://www.postgresql.org/docs/9.6/runtime-config-logging.htm
> On Mar 4, 2019, at 1:59 PM, Julie Nishimura wrote:
>
> Hello,
> Our current master 9.2 has two active standbys. Can you please help me out
> with the right sequence of events if we would like to promote one of current
> standbys to master and convert master to standby?
It depends on how yo
On Feb 28, 2019, at 8:04 AM, Stephen Frost wrote:
>
> Greetings,
>
> * Julie Nishimura (juliez...@hotmail.com) wrote:
>> Hello everybody, I am new to postgresql environment, but trying to get up to
>> speed.
>> Can you please share your experience on how you can automate refreshment of
>> dev
On Thu, Jan 17, 2019 at 4:13 PM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Thu, Jan 17, 2019 at 9:19 AM Ben Snaidero
> wrote:
> > Any ideas as to why this is happening?
>
> Not really, I would expect roughly double execution time, not an
> expon
al
time=0.002..0.004 rows=9 loops=2082)
Index Cond: (inodeid = n1ne_1.iid)
Heap Fetches: 13973
Planning time: 4.860 ms
Execution time: 16442.462 ms
(26 rows)
Thanks in advance
Ben.
Hi,
You might have to wait for pg_is_in_recovery to be false after the
promotion. (in 9.6 pg_ctl promote doesn't wait for promotion to complete
unlike 10). [1]
You should CHECKOINT between 2 and 3. (or wait for the first checkpoint to
finish)
In the thread [2], Michael Paquier explains that:
"
Do you have adequate disk space left on your array?
cheers
Ben
On 15 October 2018 at 17:46, Joshua White wrote:
> Hi all,
>
> I'm hoping someone can point me in the right direction. I've got a
> PostgreSQL 10 server instance on CentOS 6, which I set up and manage. I
&g
r.
To get around it all you have to do is script a drop and replace action.
A last word - if you have nested views, remember that they are essentially
just query aliases that return an unindexed result set...
cheers
Ben
On 16 October 2018 at 03:50, Ben Uphoff wrote:
> Hey team – I’m sure
it means I’ll have to manually change an
aggregating “parent” view’s select lists every time I change the “child” views.
Thanks for any info. -Ben
*** PLEASE NOTE *** This E-Mail/telefax message
and any documents accompanying this transmission may contain
Hi,
I am not sure what you call discrete / continuous.
pgbackrest allows backups of different kinds: full, incremental and
differential.
It keeps the wals necessary to recover since the oldest backup until the
current time.
The retention is expressed in number of full backups. You can also specif
ms it thusly:
SELECT (((mytable.ajsonbcolumn -> ‘somedata’::text) -> ‘nested’::text) ->>
‘first_name’::text) AS fname FROM mytable
(note the ::text casts).
Why does it do this? It seems unnecessary and pollutes my SQL with a ton of
extra text.
Thanks for your thoughts. -Ben
***
Hey everybody, I'm having trouble getting constraint exclusion to work on a
table partitioned with a tsrange type. I've distilled it down to this:
create table t (
id serial primary key,
observed_window tsrange not null
);
create index t_window on t(observed_window);
create table p1 (like t
Hi - this is a spreadsheet model, not a database model, and could be
modelled with three columns.
The aggregate functions are an analytic issue, not a data issue.
cheers
Ben
On 30 August 2018 at 17:13, a <372660...@qq.com> wrote:
> Hi all:
>
> I need to make a table con
/ba6132ed-1f6b-4a0b-ac22-81278f5ab...@tripadvisor.com
[2] https://www.postgresql.org/docs/9.2/static/warm-standby.html (planning
section)
Hoep this helps.
Cheers
Ben
2018-05-22 10:13 GMT+02:00 Jonatan Evald Buus <
jonatan.b...@cellpointmobile.com>:
> Thanks Ian, thank you for pointing out th
> On May 7, 2018, at 11:50 PM, Ayappan P2 wrote:
>
> We are doing "renice" on the main Postgresql process to give higher
> scheduling priority because other critical operations depends on the database.
> You are saying that the database processes take longer to relinquish their
> resources an
> On 10 May 2018, at 23:43, Adrian Klaver wrote:
>
> Trying to tame time and time zones is maybe quixotic, but not weird.
Quixotic is a very good description, I’d happily admit that using the UTC
domain in this way is not as pragmatic as I thought it would when I introduced
it.
> While I was
> On 10 May 2018, at 22:17, Peter J. Holzer wrote:
>
> I don't understand how this can work. As Francisco demonstrated,
> EXTRACT(TIMEZONE FROM ts) doesn't extract the time zone from the value
> ts, it reports the offset of the client's time zone.
Yes, you and Francisco are right.
If you do:
> On 10 May 2018, at 16:33, Francisco Olarte wrote:
>
> For what you want to do I think you'll have to parse the text value,
> maybe by definig a view with a text columns and using some
> rule/trigger magic for insert / updates.
Sorry for being unclear - the solution I have in production appea
> On 10 May 2018, at 17:38, Adrian Klaver wrote:
>
> Well if you are using a timestamp with timezone field the value is always
> going to be stored as UTC. The TimeZone setting just determines the rotation
> from the input value to the stored value and the reverse. My previous point
> was j
1 - 100 of 121 matches
Mail list logo
